public SYS_LeavewordEntity getLeavewordByLid(string LeaveID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 LeaveID,LeaveTitle,LeaveDate,LeaveContent,Operator,ReceiveID,IsRead from Sys_LeaveWord "); strSql.Append(" where LeaveID=@LeaveID "); SqlParameter[] parameters = { new SqlParameter("@LeaveID", SqlDbType.VarChar,50)}; parameters[0].Value = LeaveID; IndustryPlatform.Model.SYS_LeavewordEntity model = new IndustryPlatform.Model.SYS_LeavewordEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.LeaveID = ds.Tables[0].Rows[0]["LeaveID"].ToString(); model.LeaveTitle = ds.Tables[0].Rows[0]["LeaveTitle"].ToString(); if (ds.Tables[0].Rows[0]["LeaveDate"].ToString() != "") { model.LeaveDate = DateTime.Parse(ds.Tables[0].Rows[0]["LeaveDate"].ToString()); } model.LeaveContent = ds.Tables[0].Rows[0]["LeaveContent"].ToString(); model.Operator = ds.Tables[0].Rows[0]["Operator"].ToString(); model.ReceiveID = ds.Tables[0].Rows[0]["ReceiveID"].ToString(); model.IsRead = ds.Tables[0].Rows[0]["IsRead"].ToString(); return model; } else { return null; } }
public SYS_LeavewordEntity getLeavewordByLid(string LeaveID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 LeaveID,LeaveTitle,LeaveDate,LeaveContent,Operator,ReceiveID,IsRead from Sys_LeaveWord "); strSql.Append(" where LeaveID=@LeaveID "); SqlParameter[] parameters = { new SqlParameter("@LeaveID", SqlDbType.VarChar, 50) }; parameters[0].Value = LeaveID; IndustryPlatform.Model.SYS_LeavewordEntity model = new IndustryPlatform.Model.SYS_LeavewordEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.LeaveID = ds.Tables[0].Rows[0]["LeaveID"].ToString(); model.LeaveTitle = ds.Tables[0].Rows[0]["LeaveTitle"].ToString(); if (ds.Tables[0].Rows[0]["LeaveDate"].ToString() != "") { model.LeaveDate = DateTime.Parse(ds.Tables[0].Rows[0]["LeaveDate"].ToString()); } model.LeaveContent = ds.Tables[0].Rows[0]["LeaveContent"].ToString(); model.Operator = ds.Tables[0].Rows[0]["Operator"].ToString(); model.ReceiveID = ds.Tables[0].Rows[0]["ReceiveID"].ToString(); model.IsRead = ds.Tables[0].Rows[0]["IsRead"].ToString(); return(model); } else { return(null); } }
protected void ib_save_Click(object sender, ImageClickEventArgs e) { List<SYS_LeavewordEntity> entitys = new List<SYS_LeavewordEntity>(); if (hf_ReceiveID.Value == "") { MessageBox.Show(this.Page, "请选择接收人!"); return; } string[] receiveIDs = hf_ReceiveID.Value.Split(','); for (int i = 0; i < receiveIDs.Length; i++) { SYS_LeavewordEntity entity = new SYS_LeavewordEntity(); entity.LeaveTitle = this.txt_LEAVEtitle.Text.Trim(); entity.LeaveDate = System.DateTime.Now; entity.LeaveContent = this.txt_LEAVEcontent.Text.Trim(); entity.Operator = "1"; entity.IsRead = "0"; entity.ReceiveID = receiveIDs[i]; entitys.Add(entity); } leaveword = new SYS_Leaveword(); int result = leaveword.AddLeaveword(entitys); if (result == 1) MessageBox.Show(this.Page,"保存成功!"); else MessageBox.Show(this.Page, "保存失败!"); }