/// <summary> /// 得到一个对象实体 /// </summary> public XBase.Model.Personal.Note.NoteInfoModel GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,CompanyCD,NoteNo,NoteDate,NoteContent,Attachment,CanViewUser,CanViewUserName,ToManagerID,ManagerNote,NotedDate,Status,Creator,CreatorUserName,CreateDate,ModifiedDate,ModifiedUserID,StudyContent,MyCheckContent,UpContent,RenZhenDF,KuaiDF,ChengNuoDF,RenWuDF,LeGuanDF,ZiXinDF,FenXianDF,JieKouDF from officedba.PersonalNote "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; XBase.Model.Personal.Note.NoteInfoModel model = new XBase.Model.Personal.Note.NoteInfoModel(); DataTable dt = SqlHelper.ExecuteSql(strSql.ToString(), parameters); DataSet ds = new DataSet(); ds.Tables.Add(dt.Copy()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.CompanyCD = ds.Tables[0].Rows[0]["CompanyCD"].ToString(); model.NoteNo = ds.Tables[0].Rows[0]["NoteNo"].ToString(); if (ds.Tables[0].Rows[0]["NoteDate"].ToString() != "") { model.NoteDate = DateTime.Parse(ds.Tables[0].Rows[0]["NoteDate"].ToString()); } model.NoteContent = ds.Tables[0].Rows[0]["NoteContent"].ToString(); model.Attachment = ds.Tables[0].Rows[0]["Attachment"].ToString(); model.CanViewUser = ds.Tables[0].Rows[0]["CanViewUser"].ToString(); model.CanViewUserName = ds.Tables[0].Rows[0]["CanViewUserName"].ToString(); if (ds.Tables[0].Rows[0]["ToManagerID"].ToString() != "") { model.ToManagerID = int.Parse(ds.Tables[0].Rows[0]["ToManagerID"].ToString()); } model.ManagerNote = ds.Tables[0].Rows[0]["ManagerNote"].ToString(); if (ds.Tables[0].Rows[0]["NotedDate"].ToString() != "") { model.NotedDate = DateTime.Parse(ds.Tables[0].Rows[0]["NotedDate"].ToString()); } model.Status = ds.Tables[0].Rows[0]["Status"].ToString(); if (ds.Tables[0].Rows[0]["Creator"].ToString() != "") { model.Creator = int.Parse(ds.Tables[0].Rows[0]["Creator"].ToString()); } if (ds.Tables[0].Rows[0]["CreatorUserName"].ToString() != "") { model.CreatorUserName = ds.Tables[0].Rows[0]["CreatorUserName"].ToString(); } if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } if (ds.Tables[0].Rows[0]["ModifiedDate"].ToString() != "") { model.ModifiedDate = DateTime.Parse(ds.Tables[0].Rows[0]["ModifiedDate"].ToString()); } if (ds.Tables[0].Rows[0]["StudyContent"].ToString() != "") { model.StudyContent = ds.Tables[0].Rows[0]["StudyContent"].ToString(); } if (ds.Tables[0].Rows[0]["MyCheckContent"].ToString() != "") { model.MyCheckContent = ds.Tables[0].Rows[0]["MyCheckContent"].ToString(); } if (ds.Tables[0].Rows[0]["UpContent"].ToString() != "") { model.UpContent = ds.Tables[0].Rows[0]["UpContent"].ToString(); } if (ds.Tables[0].Rows[0]["RenZhenDF"].ToString() != "0") { try { model.RenZhenDF = int.Parse(ds.Tables[0].Rows[0]["RenZhenDF"].ToString()); } catch { model.RenZhenDF = 0; } } if (ds.Tables[0].Rows[0]["KuaiDF"].ToString() != "0") { try { model.KuaiDF = int.Parse(ds.Tables[0].Rows[0]["KuaiDF"].ToString()); } catch { model.KuaiDF = 0; } } if (ds.Tables[0].Rows[0]["ChengNuoDF"].ToString() != "0") { try { model.ChengNuoDF = int.Parse(ds.Tables[0].Rows[0]["ChengNuoDF"].ToString()); } catch { model.ChengNuoDF = 0; } } if (ds.Tables[0].Rows[0]["RenWuDF"].ToString() != "0") { try { model.RenWuDF = int.Parse(ds.Tables[0].Rows[0]["RenWuDF"].ToString()); } catch { model.RenWuDF = 0; } } if (ds.Tables[0].Rows[0]["LeGuanDF"].ToString() != "0") { try { model.LeGuanDF = int.Parse(ds.Tables[0].Rows[0]["LeGuanDF"].ToString()); } catch { model.LeGuanDF = 0; } } if (ds.Tables[0].Rows[0]["ZiXinDF"].ToString() != "0") { try { model.ZiXinDF = int.Parse(ds.Tables[0].Rows[0]["ZiXinDF"].ToString()); } catch { model.ZiXinDF = 0; } } if (ds.Tables[0].Rows[0]["FenXianDF"].ToString() != "0") { try { model.FenXianDF = int.Parse(ds.Tables[0].Rows[0]["FenXianDF"].ToString()); } catch { model.FenXianDF = 0; } } if (ds.Tables[0].Rows[0]["JieKouDF"].ToString() != "0") { try { model.JieKouDF = int.Parse(ds.Tables[0].Rows[0]["JieKouDF"].ToString()); } catch { model.JieKouDF = 0; } } model.ModifiedUserID = ds.Tables[0].Rows[0]["ModifiedUserID"].ToString(); return model; } else { return null; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XBase.Model.Personal.Note.NoteInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [officedba].PersonalNote("); strSql.Append("CompanyCD,NoteNo,NoteDate,NoteContent,Attachment,CanViewUser,CanViewUserName,ToManagerID,ManagerNote,Status,Creator,CreatorUserName,CreateDate,ModifiedDate,ModifiedUserID,StudyContent,MyCheckContent,UpContent,RenZhenDF,KuaiDF,ChengNuoDF,RenWuDF,LeGuanDF,ZiXinDF,FenXianDF,JieKouDF )"); strSql.Append(" values ("); strSql.Append("@CompanyCD,@NoteNo,@NoteDate,@NoteContent,@Attachment,@CanViewUser,@CanViewUserName,@ToManagerID,@ManagerNote,@Status,@Creator,@CreatorUserName,@CreateDate,@ModifiedDate,@ModifiedUserID,@StudyContent,@MyCheckContent,@UpContent,@RenZhenDF,@KuaiDF,@ChengNuoDF,@RenWuDF,@LeGuanDF,@ZiXinDF,@FenXianDF,@JieKouDF)"); strSql.Append(";select @ID=@@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CompanyCD", SqlDbType.VarChar, 8), new SqlParameter("@NoteNo", SqlDbType.VarChar, 50), new SqlParameter("@NoteDate", SqlDbType.DateTime), new SqlParameter("@NoteContent", SqlDbType.NText), new SqlParameter("@Attachment", SqlDbType.VarChar, 200), new SqlParameter("@CanViewUser", SqlDbType.VarChar, 1024), new SqlParameter("@CanViewUserName", SqlDbType.VarChar, 1024), new SqlParameter("@ToManagerID", SqlDbType.Int, 4), new SqlParameter("@ManagerNote", SqlDbType.VarChar, 1024), new SqlParameter("@NotedDate", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Char, 1), new SqlParameter("@Creator", SqlDbType.Int, 4), new SqlParameter("@CreatorUserName", SqlDbType.VarChar, 50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar, 50), new SqlParameter("@StudyContent", SqlDbType.VarChar, 2048), new SqlParameter("@MyCheckContent", SqlDbType.VarChar, 2048), new SqlParameter("@UpContent", SqlDbType.VarChar, 2048), new SqlParameter("@RenZhenDF", SqlDbType.Int, 4), new SqlParameter("@KuaiDF", SqlDbType.Int, 4), new SqlParameter("@ChengNuoDF", SqlDbType.Int, 4), new SqlParameter("@RenWuDF", SqlDbType.Int, 4), new SqlParameter("@LeGuanDF", SqlDbType.Int, 4), new SqlParameter("@ZiXinDF", SqlDbType.Int, 4), new SqlParameter("@FenXianDF", SqlDbType.Int, 4), new SqlParameter("@JieKouDF", SqlDbType.Int, 4), new SqlParameter("@ID", SqlDbType.Int, 0) }; parameters[0].Value = model.CompanyCD; parameters[1].Value = model.NoteNo; parameters[2].Value = model.NoteDate; parameters[3].Value = model.NoteContent; parameters[4].Value = model.Attachment; parameters[5].Value = model.CanViewUser; parameters[6].Value = model.CanViewUserName; parameters[7].Value = model.ToManagerID; parameters[8].Value = model.ManagerNote; parameters[9].Value = model.NotedDate; parameters[10].Value = model.Status; parameters[11].Value = model.Creator; parameters[12].Value = model.CreatorUserName; parameters[13].Value = model.CreateDate; parameters[14].Value = model.ModifiedDate; parameters[15].Value = model.ModifiedUserID; parameters[16].Value = model.StudyContent; parameters[17].Value = model.MyCheckContent; parameters[18].Value = model.UpContent; parameters[19].Value = model.RenZhenDF; parameters[20].Value = model.KuaiDF; parameters[21].Value = model.ChengNuoDF; parameters[22].Value = model.RenWuDF; parameters[23].Value = model.LeGuanDF; parameters[24].Value = model.ZiXinDF; parameters[25].Value = model.FenXianDF; parameters[26].Value = model.JieKouDF; parameters[27].Direction = ParameterDirection.Output; SqlHelper.ExecuteTransSql(strSql.ToString(), parameters); return(int.Parse(parameters[27].Value.ToString())); }
/// <summary> /// 得到一个对象实体 /// </summary> public XBase.Model.Personal.Note.NoteInfoModel GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,CompanyCD,NoteNo,NoteDate,NoteContent,Attachment,CanViewUser,CanViewUserName,ToManagerID,ManagerNote,NotedDate,Status,Creator,CreatorUserName,CreateDate,ModifiedDate,ModifiedUserID,StudyContent,MyCheckContent,UpContent,RenZhenDF,KuaiDF,ChengNuoDF,RenWuDF,LeGuanDF,ZiXinDF,FenXianDF,JieKouDF from officedba.PersonalNote "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; XBase.Model.Personal.Note.NoteInfoModel model = new XBase.Model.Personal.Note.NoteInfoModel(); DataTable dt = SqlHelper.ExecuteSql(strSql.ToString(), parameters); DataSet ds = new DataSet(); ds.Tables.Add(dt.Copy()); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.CompanyCD = ds.Tables[0].Rows[0]["CompanyCD"].ToString(); model.NoteNo = ds.Tables[0].Rows[0]["NoteNo"].ToString(); if (ds.Tables[0].Rows[0]["NoteDate"].ToString() != "") { model.NoteDate = DateTime.Parse(ds.Tables[0].Rows[0]["NoteDate"].ToString()); } model.NoteContent = ds.Tables[0].Rows[0]["NoteContent"].ToString(); model.Attachment = ds.Tables[0].Rows[0]["Attachment"].ToString(); model.CanViewUser = ds.Tables[0].Rows[0]["CanViewUser"].ToString(); model.CanViewUserName = ds.Tables[0].Rows[0]["CanViewUserName"].ToString(); if (ds.Tables[0].Rows[0]["ToManagerID"].ToString() != "") { model.ToManagerID = int.Parse(ds.Tables[0].Rows[0]["ToManagerID"].ToString()); } model.ManagerNote = ds.Tables[0].Rows[0]["ManagerNote"].ToString(); if (ds.Tables[0].Rows[0]["NotedDate"].ToString() != "") { model.NotedDate = DateTime.Parse(ds.Tables[0].Rows[0]["NotedDate"].ToString()); } model.Status = ds.Tables[0].Rows[0]["Status"].ToString(); if (ds.Tables[0].Rows[0]["Creator"].ToString() != "") { model.Creator = int.Parse(ds.Tables[0].Rows[0]["Creator"].ToString()); } if (ds.Tables[0].Rows[0]["CreatorUserName"].ToString() != "") { model.CreatorUserName = ds.Tables[0].Rows[0]["CreatorUserName"].ToString(); } if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString()); } if (ds.Tables[0].Rows[0]["ModifiedDate"].ToString() != "") { model.ModifiedDate = DateTime.Parse(ds.Tables[0].Rows[0]["ModifiedDate"].ToString()); } if (ds.Tables[0].Rows[0]["StudyContent"].ToString() != "") { model.StudyContent = ds.Tables[0].Rows[0]["StudyContent"].ToString(); } if (ds.Tables[0].Rows[0]["MyCheckContent"].ToString() != "") { model.MyCheckContent = ds.Tables[0].Rows[0]["MyCheckContent"].ToString(); } if (ds.Tables[0].Rows[0]["UpContent"].ToString() != "") { model.UpContent = ds.Tables[0].Rows[0]["UpContent"].ToString(); } if (ds.Tables[0].Rows[0]["RenZhenDF"].ToString() != "0") { try { model.RenZhenDF = int.Parse(ds.Tables[0].Rows[0]["RenZhenDF"].ToString()); } catch { model.RenZhenDF = 0; } } if (ds.Tables[0].Rows[0]["KuaiDF"].ToString() != "0") { try { model.KuaiDF = int.Parse(ds.Tables[0].Rows[0]["KuaiDF"].ToString()); } catch { model.KuaiDF = 0; } } if (ds.Tables[0].Rows[0]["ChengNuoDF"].ToString() != "0") { try { model.ChengNuoDF = int.Parse(ds.Tables[0].Rows[0]["ChengNuoDF"].ToString()); } catch { model.ChengNuoDF = 0; } } if (ds.Tables[0].Rows[0]["RenWuDF"].ToString() != "0") { try { model.RenWuDF = int.Parse(ds.Tables[0].Rows[0]["RenWuDF"].ToString()); } catch { model.RenWuDF = 0; } } if (ds.Tables[0].Rows[0]["LeGuanDF"].ToString() != "0") { try { model.LeGuanDF = int.Parse(ds.Tables[0].Rows[0]["LeGuanDF"].ToString()); } catch { model.LeGuanDF = 0; } } if (ds.Tables[0].Rows[0]["ZiXinDF"].ToString() != "0") { try { model.ZiXinDF = int.Parse(ds.Tables[0].Rows[0]["ZiXinDF"].ToString()); } catch { model.ZiXinDF = 0; } } if (ds.Tables[0].Rows[0]["FenXianDF"].ToString() != "0") { try { model.FenXianDF = int.Parse(ds.Tables[0].Rows[0]["FenXianDF"].ToString()); } catch { model.FenXianDF = 0; } } if (ds.Tables[0].Rows[0]["JieKouDF"].ToString() != "0") { try { model.JieKouDF = int.Parse(ds.Tables[0].Rows[0]["JieKouDF"].ToString()); } catch { model.JieKouDF = 0; } } model.ModifiedUserID = ds.Tables[0].Rows[0]["ModifiedUserID"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(XBase.Model.Personal.Note.NoteInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [officedba].PersonalNote set "); strSql.Append("CompanyCD=@CompanyCD,"); strSql.Append("NoteNo=@NoteNo,"); // strSql.Append("NoteDate=@NoteDate,"); strSql.Append("NoteContent=@NoteContent,"); strSql.Append("Attachment=@Attachment,"); strSql.Append("CanViewUser=@CanViewUser,"); strSql.Append("CanViewUserName=@CanViewUserName,"); strSql.Append("ToManagerID=@ToManagerID,"); strSql.Append("ManagerNote=@ManagerNote,"); if (model.NotedDate != new DateTime(1900, 1, 1)) { strSql.Append("NotedDate=@NotedDate,"); } strSql.Append("Status=@Status,"); strSql.Append("Creator=@Creator,"); strSql.Append("CreatorUserName=@CreatorUserName,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("ModifiedDate=@ModifiedDate,"); strSql.Append("ModifiedUserID=@ModifiedUserID,"); strSql.Append("StudyContent=@StudyContent,"); strSql.Append("MyCheckContent=@MyCheckContent,"); strSql.Append("UpContent=@UpContent,"); strSql.Append("RenZhenDF=@RenZhenDF,"); strSql.Append("KuaiDF=@KuaiDF,"); strSql.Append("ChengNuoDF=@ChengNuoDF,"); strSql.Append("RenWuDF=@RenWuDF,"); strSql.Append("LeGuanDF=@LeGuanDF,"); strSql.Append("ZiXinDF=@ZiXinDF,"); strSql.Append("FenXianDF=@FenXianDF,"); strSql.Append("JieKouDF=@JieKouDF "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@CompanyCD", SqlDbType.VarChar, 8), new SqlParameter("@NoteNo", SqlDbType.VarChar, 50), new SqlParameter("@NoteDate", SqlDbType.DateTime), new SqlParameter("@NoteContent", SqlDbType.NText), new SqlParameter("@Attachment", SqlDbType.VarChar, 200), new SqlParameter("@CanViewUser", SqlDbType.VarChar, 1024), new SqlParameter("@CanViewUserName", SqlDbType.VarChar, 1024), new SqlParameter("@ToManagerID", SqlDbType.Int, 4), new SqlParameter("@ManagerNote", SqlDbType.VarChar, 1024), new SqlParameter("@NotedDate", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Char, 1), new SqlParameter("@Creator", SqlDbType.Int, 4), new SqlParameter("@CreatorUserName", SqlDbType.VarChar, 50), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ModifiedDate", SqlDbType.DateTime), new SqlParameter("@ModifiedUserID", SqlDbType.VarChar, 50), new SqlParameter("@StudyContent", SqlDbType.VarChar, 2048), new SqlParameter("@MyCheckContent", SqlDbType.VarChar, 2048), new SqlParameter("@UpContent", SqlDbType.VarChar, 2048), new SqlParameter("@RenZhenDF", SqlDbType.Int, 4), new SqlParameter("@KuaiDF", SqlDbType.Int, 4), new SqlParameter("@ChengNuoDF", SqlDbType.Int, 4), new SqlParameter("@RenWuDF", SqlDbType.Int, 4), new SqlParameter("@LeGuanDF", SqlDbType.Int, 4), new SqlParameter("@ZiXinDF", SqlDbType.Int, 4), new SqlParameter("@FenXianDF", SqlDbType.Int, 4), new SqlParameter("@JieKouDF", SqlDbType.Int, 4) }; parameters[0].Value = model.ID; parameters[1].Value = model.CompanyCD; parameters[2].Value = model.NoteNo; parameters[3].Value = model.NoteDate; parameters[4].Value = model.NoteContent; parameters[5].Value = model.Attachment; parameters[6].Value = model.CanViewUser; parameters[7].Value = model.CanViewUserName; parameters[8].Value = model.ToManagerID; parameters[9].Value = model.ManagerNote; parameters[10].Value = model.NotedDate; parameters[11].Value = model.Status; parameters[12].Value = model.Creator; parameters[13].Value = model.CreatorUserName; parameters[14].Value = model.CreateDate; parameters[15].Value = model.ModifiedDate; parameters[16].Value = model.ModifiedUserID; parameters[17].Value = model.StudyContent; parameters[18].Value = model.MyCheckContent; parameters[19].Value = model.UpContent; parameters[20].Value = model.RenZhenDF; parameters[21].Value = model.KuaiDF; parameters[22].Value = model.ChengNuoDF; parameters[23].Value = model.RenWuDF; parameters[24].Value = model.LeGuanDF; parameters[25].Value = model.ZiXinDF; parameters[26].Value = model.FenXianDF; parameters[27].Value = model.JieKouDF; SqlHelper.ExecuteTransSql(strSql.ToString(), parameters); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(XBase.Model.Personal.Note.NoteInfoModel model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(XBase.Model.Personal.Note.NoteInfoModel model) { return(dal.Add(model)); }