/// <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));
}
