public static ManualSign GetManualSignById(int newId)
{
string sql = "select * from manualsign where signId=" + newId;
string userId = "";
SqlDataReader reader = DBHelper.GetReader(sql);
if (reader.Read())
{
ManualSign m = new ManualSign();
m.SignId = Convert.ToInt32(reader["signId"]);
m.SignTag = Convert.ToInt32(reader["signTag"]);
m.SignTime = Convert.ToDateTime(reader["signTime"]);
m.SignDesc = Convert.ToString(reader["signDesc"]);
userId = Convert.ToString(reader["userId"]);
reader.Close();
m.User = UserService.GetUserById(userId);
return(m);
}
else
{
reader.Close();
return(null);
}
}
public static void ModifyManualSign(ManualSign manualSign)
{
string sql =
"UPDATE ManualSign " +
"SET " +
"UserId = @UserId, " + //FK
"SignTime = @SignTime, " +
"SignDesc = @SignDesc, " +
"SignTag = @SignTag " +
"WHERE SignId = @SignId";
try
{
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@SignId", manualSign.SignId),
new SqlParameter("@UserId", manualSign.User.UserId), //FK
new SqlParameter("@SignTime", manualSign.SignTime),
new SqlParameter("@SignDesc", manualSign.SignDesc),
new SqlParameter("@SignTag", manualSign.SignTag)
};
DBHelper.ExecuteCommand(sql, para);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 保存考勤信息
/// </summary>
/// <param name="f*g">0签到 1签退</param>
/// <returns></returns>
private ManualSign Save(int f*g)
{
ManualSign ms = new ManualSign();
ms.User = (Session["Login"] as User);
ms.SignTime = DateTime.Parse(DateTime.Now.ToString());
ms.SignTag = f*g;
ms.SignDesc = txtSignDesc.Text.Trim();
ms = ManualSignManager.AddManualSign(ms);
FillManual(f*g, ms);
return(ms);
}
private void FillManual(int f*g, ManualSign ms)
{
//初始化签到签退信息
string line = "----";
sign.Text = (f*g == 0) ? "签到" : "签退";
txtUserId.Text = line + ms.User.UserId;
txtUserName.Text = line + ms.User.UserName;
Depart depart = DepartInfoManager.GetDepartGetById(ms.User.DepartId);
txtDepart.Text = line + depart.DepartName.Trim();
txtBranch.Text = line + depart.Branch.BranchName;
txtSignInDesc.Text = line + ms.SignDesc;
txtSignTimeInfo.Text = line + ms.SignTime.ToString();
}
public static ManualSign AddManualSign(ManualSign manualSign)
{
string sql = "insert into manualsign (userId,signtime,signdesc,signtag)values(@uId,@signTime,@signdesc,@signTag)";
sql += ";select @@identity ";
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@uId", manualSign.User.UserId),
new SqlParameter("@signTime", manualSign.SignTime),
new SqlParameter("@signdesc", manualSign.SignDesc),
new SqlParameter("@signTag", manualSign.SignTag)
};
int newId = Convert.ToInt32(DBHelper.GetScalar(sql, para));
return(GetManualSignById(newId));
}
//签退
protected void SignOut_Click(object sender, EventArgs e)
{
int count = ManualSignManager.GetManualSignState(false, (Session["Login"] as User).UserId);
if (count < 1)
{
ManualSign ms = Save(1);
if (ms != null)
{
divExit.Visible = true;
//直接进行相应的按钮显隐藏就行了； 不用再调用判断的InitInterface方法了；
this.btnSignOut.Enabled = false;
this.btnSignIn.Enabled = true;
}
}
}
public static IList <ManualSign> GetManualSignBySql(string sql)
{
IList <ManualSign> list = new List <ManualSign>();
DataTable table = DBHelper.GetDataSet(sql);
foreach (DataRow row in table.Rows)
{
ManualSign m = new ManualSign();
m.SignId = Convert.ToInt32(row["signId"]);
m.SignTag = Convert.ToInt32(row["signTag"]);
m.SignTime = Convert.ToDateTime(row["signTime"]);
m.SignDesc = Convert.ToString(row["signDesc"]);
m.User = UserService.GetUserById(Convert.ToString(row["userId"]));
list.Add(m);
}
return(list);
}
//签到
protected void SignIn_Click(object sender, EventArgs e)
{
int count = ManualSignManager.GetManualSignState(true, (Session["Login"] as User).UserId);
if (count < 1)
{
ManualSign ms = Save(0);
if (ms != null)
{
divExit.Visible = true;
//直接进行相应的按钮显隐藏就行了； 不用再调用判断的InitInterface方法了；
this.btnSignIn.Enabled = false;
this.btnSignOut.Enabled = true;
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "key", "alert('您今天已经签过到了！签到信息如下：')", true);
//调用判断的InitInterface方法了；
InitInterface();
}
}
public static void ModifyManualSign(ManualSign manualSign)
{
ManualSignService.ModifyManualSign(manualSign);
}
public static ManualSign AddManualSign(ManualSign manualSign)
{
return(ManualSignService.AddManualSign(manualSign));
}
