本文整理汇总了C#中DB.reDr方法的典型用法代码示例。如果您正苦于以下问题:C# DB.reDr方法的具体用法?C# DB.reDr怎么用?C# DB.reDr使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DB
的用法示例。
在下文中一共展示了DB.reDr方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetJobName
public string GetJobName(object jobskyerID) //把jobskyerID转化为jobName输出
{
DB db = new DB();
SqlDataReader dr = db.reDr("SELECT jobName FROM jobskyer WHERE jobskyerID='" + jobskyerID + "'");
dr.Read();
return dr.GetValue(0).ToString();
}
示例2: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DB db = new DB();
if (!IsPostBack)
{
SqlDataReader dr0 = db.reDr("select jobImage from jobskyer where jobskyerID='" + Session["jobskyerID"] + "'");
dr0.Read();
if (dr0.HasRows)
{
imageUrl = "../Change/Picture/" + dr0["jobImage"].ToString();
}
else
{
imageUrl = "../Image/JsCommonMain/Business.jpg";
}
dr0.Close();
}
}
示例3: printAphorism
public void printAphorism()
{
try
{
DB db = new DB();
string jobName = HttpContext.Current.User.Identity.Name;
SqlDataReader dr = db.reDr("SELECT jobName,aphorism FROM jobskyer,jobAphorism WHERE jobName='" + jobName + "' AND jobskyer.aphorismID=jobAphorism.aphorismID");
dr.Read();
string str = dr.GetValue(0).ToString();
SqlConnection con = new SqlConnection();
con = db.GetCon();
con.Open();
SqlCommand com = new SqlCommand(str, con);
SqlDataAdapter da = new SqlDataAdapter(com);
DataSet ds = new DataSet();//using System.Data;
da.Fill(ds);
ds.Dispose();
da.Dispose();
if (ds != null)
{
AphorismRepeater.DataSource = ds;
AphorismRepeater.DataBind();
}
con.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
示例4: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
DB db = new DB();
printAphorism();
if (!IsPostBack)
{
SqlDataReader dr0 = db.reDr("select jobImage from jobskyer where jobskyerID='" + Session["jobskyerID"] + "'");
dr0.Read();
if (dr0.HasRows)
{
imageUrl = "../Change/Picture/" + dr0["jobImage"].ToString();
}
else
{
imageUrl = "../Image/JsCommonMain/Business.jpg";
}
dr0.Close();
}
//判断用户是否已登录
string jobName = HttpContext.Current.User.Identity.Name;
if (HttpContext.Current.User.Identity.Name == "" || HttpContext.Current.User.Identity.Name == null)
{
//用户未登录
Response.Redirect("~/JsCommon/Login.aspx");
}
else
{
//用户已登录
try
{
SqlDataReader dr1 = db.reDr("select jobAcademy,jobPosition from jobskyer where jobName='" + jobName + "'");
dr1.Read();
lblName.Text = HttpContext.Current.User.Identity.Name;
if (dr1.HasRows)
{
lblAcademy.Text = dr1.GetValue(0).ToString();
lblPosition.Text = dr1.GetValue(1).ToString();
//lblCount.Text = dr1.GetValue(2).ToString();
}
else
{
Response.Write("找不到此用户!");
}
dr1.Dispose();
dr1.Close();
//dr2.Close();
}
catch
{
Response.Write("<script>alert('连接出错')</script>");
}
finally
{
}
}
//string imgUrl;
////imgUrl= 默认头像
////jobskyerID = Session["jobskyerID"].ToString();
//SqlDataReader dr2 = db.reDr("SELECT jobImage FROM jobskyer WHERE jobName='" + jobName + "'");
//dr2.Read();
//imgUrl = dr2.GetValue(0).ToString().Trim();
//dr2.Dispose();
//dr2.Close();
}
示例5: ImgbtnSignIn_Click
protected void ImgbtnSignIn_Click(object sender, ImageClickEventArgs e)
{
DB db = new DB();
DateTime nowTime = DateTime.Now;
if (ImgbtnSignIn.ImageUrl.ToString() == "~/Image/Sign/SignIn.PNG")
{
try
{
string dutyInTimeSql = "SELECT dutyInTime FROM dutyTimeTable WHERE jobskyerID='" + Session["jobskyerID"] + "'";//and dutyInTime='"+nowTime.ToString()+"'";
SqlDataReader dutyInTimeDr = db.reDr(dutyInTimeSql);
dutyInTimeDr.Read();
if(dutyInTimeDr.GetValue(0).ToString()!=null)
{
int flag0=0;
DateTime dutyInTime = Convert.ToDateTime(dutyInTimeDr.GetValue(0).ToString());
if (dutyInTime.DayOfWeek == nowTime.DayOfWeek && differOfTime(Convert.ToDateTime(dutyInTime), nowTime) >= 0 && dutyInTime.DayOfWeek == nowTime.DayOfWeek && differOfTime(Convert.ToDateTime(dutyInTime), nowTime)<=30)
{
flag0=0;
}
else if (differOfTime(Convert.ToDateTime(dutyInTime), nowTime) < 0 && dutyInTime.DayOfWeek == nowTime.DayOfWeek && differOfTime(Convert.ToDateTime(dutyInTime), nowTime)>=-60)
{
flag0=1;
}
string recordInsert = "INSERT INTO myDutyTime(jobskyerID,dutyInTime,flag0,toJobskyerID) values('" + Session["jobskyerID"] + "','" + nowTime.ToString() + "','" + flag0 + "','" + Session["jobskyerID"] + "')";
Session["dutyInTime"] = nowTime.ToString();
if(db.SqlEX(recordInsert)==1)
{
Response.Write("<script>alert('签到成功')</script>");
lblMessage.Visible = true;
//lblMessage.Text = Session["jobName"] + "正在值班...";
//flag = 1;
}
else
{
lblMessage.Visible = true;
lblMessage.Text="签到失败!";
}
}
dutyInTimeDr.Close();
}
catch
{
Response.Write("<script>alert('可能是登录过期,请重新登录')</script>");
Response.Redirect("~/JsCommon/Login.aspx");
}
finally
{
}
}
//代班签到
else if (ImgbtnSignIn.ImageUrl == "~/Image/Sign/SignInTo.PNG")
{
if(DLSignInTo.SelectedValue.ToString()=="请选择被代班人:")
{
return;
}
else
{
try
{
Session["toJobName"] = DLSignInTo.SelectedValue.ToString();
SqlDataReader toJobId = db.reDr("SELECT JobskyerID FROM jobskyer WHERE jobName='" + Session["toJobName"] + "'");
toJobId.Read();
if (toJobId.HasRows)
{
Session["toJobskyerID"] = toJobId.GetValue(0).ToString();
}
string dutyInTimeSql = "SELECT dutyInTime FROM dutyTimeTable WHERE jobskyerID='" + Session["toJobskyerID"] + "'";//and dutyInTime='"+nowTime.ToString()+"'";
SqlDataReader dutyInTimeDr = db.reDr(dutyInTimeSql);
dutyInTimeDr.Read();
if (dutyInTimeDr.GetValue(0).ToString() != null)
{
int flag0 = 0;
DateTime dutyInTime = Convert.ToDateTime(dutyInTimeDr.GetValue(0).ToString());
if (dutyInTime.DayOfWeek == nowTime.DayOfWeek && differOfTime(Convert.ToDateTime(dutyInTime), nowTime) >= 0 && dutyInTime.DayOfWeek == nowTime.DayOfWeek && differOfTime(Convert.ToDateTime(dutyInTime), nowTime) <= 30)
{
//准时签到
flag0 = 0;
}
else if (differOfTime(Convert.ToDateTime(dutyInTime), nowTime) < 0 && dutyInTime.DayOfWeek == nowTime.DayOfWeek && differOfTime(Convert.ToDateTime(dutyInTime), nowTime) >= -60)
{
//迟到
flag0 = 1;
}
string recordInsert = "INSERT INTO myDutyTime(jobskyerID,dutyInTime,flag0,toJobskyerID) values('" + Session["jobskyerID"] + "','" + nowTime.ToString() + "','" + flag0 + "','" + Session["toJobskyerID"] + "')";
Session["dutyInTime"] = nowTime.ToString();
if (db.SqlEX(recordInsert) == 1)
{
//签到成功
DLSignInTo.Visible = false;
DLSignInTo.Enabled = false;
ImgbtnSignIn.Visible = false;
ImgbtnSignIn.Enabled = false;
lblMessage.Visible = true;
lblMessage.Text = Session["jobName"] + "给" + DLSignInTo.SelectedValue.ToString() + "代班签到成功";
//.........这里部分代码省略.........
示例6: ShowButton
//.........这里部分代码省略.........
}
}
}
else if(differOfTime(nowTime,dutyOutTime)>60)
{
//Response.Write("3");
//Response.Write(dutyOutTime);
flag = 0;
ImgbtnSignIn.ImageUrl = "~/Image/Sign/SignIn.PNG";
DLSignInTo.Visible = false;
DLSignInTo.Enabled = false;
}
}
}
}
}
//判断签到代签按钮是否可用
//签到
if(ds!=null&&ds.Tables.Count>0&&ds.Tables[0].Rows.Count>0&&flag==0)
{
//Response.Write("3");
for(int i=0;i<ds.Tables[0].Rows.Count;i++)
{
if(ds.Tables[0].Rows[i]["jobskyerID"].ToString().Trim()==Session["jobskyerID"].ToString())
{
if(ds.Tables[1].Rows.Count>0)
{
for (int j = 0; j < ds.Tables[1].Rows.Count; j++)
{
//Response.Write(ds.Tables[1].Rows[j]["flag2"].ToString() == "2");
//检查当天是否已值班(被代班)
if (Convert.ToDateTime(ds.Tables[1].Rows[j]["dutyInTime"].ToString()).DayOfWeek == nowTime.DayOfWeek && ds.Tables[1].Rows[j]["jobskyerID"].ToString() != Session["jobskyerID"].ToString() && ds.Tables[1].Rows[j]["toJobskyerID"].ToString() == Session["jobskyerID"].ToString() && nowTime.DayOfWeek.ToString() == Convert.ToDateTime(ds.Tables[0].Rows[i]["dutyInTime"]).DayOfWeek.ToString() && ds.Tables[1].Rows[j]["flag2"].ToString() == "2")
{
SqlDataReader dr = db.reDr("SELECT jobName FROM jobskyer WHERE jobskyerID='" + ds.Tables[1].Rows[j]["jobskyerID"] + "'"); //and dutyInTime='"+nowTime.ToString()+"'");
dr.Read();
lblMessage.Visible = true;
lblMessage.Text = "正在被" + dr.GetValue(0) + "代班";
flag = 0;
ImgbtnSignIn.Enabled = false;
ImgbtnSignIn.Visible = false;
break;
}
else if (j == ds.Tables[1].Rows.Count - 1 && ds.Tables[1].Rows[j]["toJobskyerID"] != Session["jobskyerID"])
{
dutyInTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["dutyInTime"].ToString());
//判断当前时间是否在签到时间内
if (dutyInTime.DayOfWeek == nowTime.DayOfWeek && differOfTime(Convert.ToDateTime(dutyInTime), nowTime) <= 30 && differOfTime(Convert.ToDateTime(dutyInTime), nowTime) >= -60)
{
flag = 1;
lblMessage.Visible = false;
ImgbtnSignIn.Enabled = true;
ImgbtnSignIn.Visible = true;
ImgbtnSignIn.ImageUrl = "~/Image/Sign/SignIn.PNG";//不必要
break;
}
}
}
}
else
{
dutyInTime = Convert.ToDateTime(ds.Tables[0].Rows[i]["dutyInTime"].ToString());
//判断当前时间是否在签到时间内
if (dutyInTime.DayOfWeek == nowTime.DayOfWeek && differOfTime(Convert.ToDateTime(dutyInTime), nowTime) <= 30 && differOfTime(Convert.ToDateTime(dutyInTime), nowTime) >= -60)
{
flag = 1;
lblMessage.Visible = false;