protected void btnSave_Click(object sender, EventArgs e)
{
int UserId = int.Parse(Session["userid"].ToString());
int TypeId = int.Parse(ddlTylpe.SelectedValue);
int Money = 0;
DateTime sTime = Convert.ToDateTime(txtSTime.Text);
DateTime eTime = Convert.ToDateTime(txtETime.Text);
UserInfosInfo info = GetModel(UserId);
TimeSpan span = eTime - sTime;
if (TypeId == 1) //事假 100
{
Money = -Convert.ToInt32(info.Salary) / 30 * span.Days;
}
else if (TypeId == 0)//病假 50
{
Money = -Convert.ToInt32(info.Salary) / 60 * span.Days;
}
string Remark = this.txtRemark.Text;
DateTime SubTime = DateTime.Now;
VacateInfosInfo model = new VacateInfosInfo();
model.UserId = UserId;
model.TypeId = TypeId;
model.Money = Money;
model.Remark = Remark;
model.SubTime = SubTime;
model.StartTime = sTime;
model.EndTime = eTime;
Add(model);
}
public void Add(VacateInfosInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into VacateInfos(");
strSql.Append("UserId,TypeId,Money,Remark,SubTime,StartTime,EndTime)");
strSql.Append(" values (");
strSql.Append("'" + model.UserId + "','" + model.TypeId + "','" + model.Money + "','" + model.Remark + "','" + model.SubTime + "','" + model.StartTime + "','" + model.EndTime + "')");
strSql.Append(";select @@IDENTITY");
SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
scon.Open();
SqlCommand scmd = new SqlCommand(strSql.ToString(), scon);
scmd.ExecuteScalar();
scmd.Dispose();
scon.Close();
Response.Write("<script language='javascript'>alert('添加成功！');</script>");
Server.Transfer("list.aspx");
}
