/// <summary>
/// 执行列表查询
/// </summary>
/// <param name="dc"></param>
/// <returns></returns>
private IList <EyouSoft.Model.ToolStructure.CompanyDayMemo> GetQueryList(DbCommand dc)
{
IList <EyouSoft.Model.ToolStructure.CompanyDayMemo> list = new List <EyouSoft.Model.ToolStructure.CompanyDayMemo>();
using (IDataReader dr = this.SystemStore.ExecuteReader(dc))
{
EyouSoft.Model.ToolStructure.CompanyDayMemo model = null;
while (dr.Read())
{
model = new EyouSoft.Model.ToolStructure.CompanyDayMemo();
model.ID = dr["ID"].ToString();
model.MemoTitle = dr["MemoTitle"].ToString();
model.MemoText = dr["MemoText"].ToString();
if (dr["UrgentType"].ToString() != "")
{
model.UrgentType = (EyouSoft.Model.ToolStructure.MemoDetailType.UrgentType) int.Parse(dr["UrgentType"].ToString());
}
if (dr["MemoState"].ToString() != "")
{
model.MemoState = (EyouSoft.Model.ToolStructure.MemoDetailType.MemoState) int.Parse(dr["MemoState"].ToString());
}
if (dr["IssueTime"].ToString() != "")
{
model.IssueTime = DateTime.Parse(dr["IssueTime"].ToString());
}
if (dr["MemoTime"].ToString() != "")
{
model.MemoTime = DateTime.Parse(dr["MemoTime"].ToString());
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">备忘录实体</param>
/// <returns></returns>
public virtual int Update(EyouSoft.Model.ToolStructure.CompanyDayMemo model)
{
DbCommand dc = this.SystemStore.GetSqlStringCommand(SQL_CompanyDayMemo_UPDATE);
this.CompanyStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID);
this.CompanyStore.AddInParameter(dc, "MemoTitle", DbType.String, model.MemoTitle);
this.CompanyStore.AddInParameter(dc, "MemoText", DbType.String, model.MemoText);
this.CompanyStore.AddInParameter(dc, "UrgentType", DbType.Int16, model.UrgentType);
this.CompanyStore.AddInParameter(dc, "MemoState", DbType.Int16, model.MemoState);
this.CompanyStore.AddInParameter(dc, "MemoTime", DbType.DateTime, model.MemoTime);
return(DbHelper.ExecuteSql(dc, this.CompanyStore));
}
protected void ShowMemoInfo(string memId)
{
EyouSoft.Model.ToolStructure.CompanyDayMemo dayMemo = EyouSoft.BLL.ToolStructure.CompanyDayMemo.CreateInstance().GetModel(memId);
if (dayMemo != null)
{
DatePicker1.Value = dayMemo.MemoTime.ToString("yyyy-MM-dd");
txtTitle.Value = dayMemo.MemoTitle;
txtDetialInfo.Value = dayMemo.MemoText;
ddlUrgentType.SelectedValue = dayMemo.UrgentType.ToString();
ddlMemState.SelectedValue = dayMemo.MemoState.ToString();
dayMemo = null;
}
hdfMemID.Value = memId;
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model">备忘录实体</param>
/// <returns></returns>
public virtual int Add(EyouSoft.Model.ToolStructure.CompanyDayMemo model)
{
DbCommand dc = this.SystemStore.GetSqlStringCommand(SQL_CompanyDayMemo_ADD);
this.CompanyStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, Guid.NewGuid().ToString());
this.CompanyStore.AddInParameter(dc, "CompanyId", DbType.String, model.CompanyId);
this.CompanyStore.AddInParameter(dc, "MemoTitle", DbType.String, model.MemoTitle);
this.CompanyStore.AddInParameter(dc, "MemoText", DbType.String, model.MemoText);
this.CompanyStore.AddInParameter(dc, "UrgentType", DbType.Int16, model.UrgentType);
this.CompanyStore.AddInParameter(dc, "MemoState", DbType.Int16, model.MemoState);
this.CompanyStore.AddInParameter(dc, "OperatorName", DbType.String, model.OperatorName);
this.CompanyStore.AddInParameter(dc, "OperatorId", DbType.String, model.OperatorId);
this.CompanyStore.AddInParameter(dc, "MemoTime", DbType.DateTime, model.MemoTime);
return(DbHelper.ExecuteSql(dc, this.CompanyStore));
}
/// <summary>
/// 获取备忘录实体
/// </summary>
/// <param name="MemoId">主键编号</param>
/// <returns></returns>
public virtual EyouSoft.Model.ToolStructure.CompanyDayMemo GetModel(string MemoId)
{
EyouSoft.Model.ToolStructure.CompanyDayMemo model = null;
DbCommand dc = this.SystemStore.GetSqlStringCommand(SQL_CompanyDayMemo_MODEL);
this.CompanyStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, MemoId);
DataTable dt = DbHelper.DataTableQuery(dc, this.CompanyStore);
foreach (DataRow dr in dt.Rows)
{
model = new EyouSoft.Model.ToolStructure.CompanyDayMemo();
model.ID = dr["ID"].ToString();
model.CompanyId = dr["CompanyId"].ToString();
model.MemoTitle = dr["MemoTitle"].ToString();
model.MemoText = dr["MemoText"].ToString();
if (dr["UrgentType"].ToString() != "")
{
model.UrgentType = (EyouSoft.Model.ToolStructure.MemoDetailType.UrgentType) int.Parse(dr["UrgentType"].ToString());
}
if (dr["MemoState"].ToString() != "")
{
model.MemoState = (EyouSoft.Model.ToolStructure.MemoDetailType.MemoState) int.Parse(dr["MemoState"].ToString());
}
model.OperatorName = dr["OperatorName"].ToString();
model.OperatorId = dr["OperatorId"].ToString();
if (dr["IssueTime"].ToString() != "")
{
model.IssueTime = DateTime.Parse(dr["IssueTime"].ToString());
}
if (dr["MemoTime"].ToString() != "")
{
model.MemoTime = DateTime.Parse(dr["MemoTime"].ToString());
}
dt.Dispose();
}
return(model);
}
/// <summary>
/// 修改公司备忘录
/// </summary>
/// <param name="model">备忘录信息</param>
/// <returns>操作结果</returns>
public bool Update(EyouSoft.Model.ToolStructure.CompanyDayMemo model)
{
return(DAL.Update(model) > 0 ? true : false);
}
private void SaveMem()
{
string title = Utils.GetFormValue(txtTitle.UniqueID);
string datetime = Utils.GetFormValue(DatePicker1.UniqueID);
string urgent = Utils.GetFormValue(ddlUrgentType.UniqueID);
string detailinfo = Utils.GetFormValue(txtDetialInfo.UniqueID);
string memostate = Utils.GetFormValue(ddlMemState.UniqueID);
if (title.Length <= 0)
{
Response.Write("请填写事件标题!");
Response.End();
return;
}
if (!StringValidate.IsDateTime(datetime))
{
Response.Write("请填写正确的时间!");
Response.End();
return;
}
if (urgent.Length <= 0)
{
Response.Write("请选择事件紧急程度!");
Response.End();
return;
}
if (memostate.Length <= 0)
{
Response.Write("请选择事件状态!");
Response.End();
return;
}
EyouSoft.Model.ToolStructure.CompanyDayMemo dayMemo = new EyouSoft.Model.ToolStructure.CompanyDayMemo();
dayMemo.MemoText = detailinfo;
dayMemo.MemoTitle = title;
dayMemo.OperatorId = this.SiteUserInfo.ID;
dayMemo.OperatorName = this.SiteUserInfo.UserName;
dayMemo.UrgentType = (EyouSoft.Model.ToolStructure.MemoDetailType.UrgentType)Enum.Parse(typeof(EyouSoft.Model.ToolStructure.MemoDetailType.UrgentType), urgent);
dayMemo.MemoTime = Convert.ToDateTime(datetime);
dayMemo.CompanyId = this.SiteUserInfo.CompanyID;
dayMemo.MemoState = (EyouSoft.Model.ToolStructure.MemoDetailType.MemoState)Enum.Parse(typeof(EyouSoft.Model.ToolStructure.MemoDetailType.MemoState), memostate);
bool result = false;
string memId = Utils.GetFormValue(hdfMemID.UniqueID);
if (!string.IsNullOrEmpty(memId))
{
//修改
dayMemo.ID = memId;
result = EyouSoft.BLL.ToolStructure.CompanyDayMemo.CreateInstance().Update(dayMemo);
}
else
{
//新增
dayMemo.IssueTime = DateTime.Now;
result = EyouSoft.BLL.ToolStructure.CompanyDayMemo.CreateInstance().Add(dayMemo);
}
if (result)
{
Response.Write("操作成功!");
Response.End();
}
else
{
Response.Write("操作失败!");
Response.End();
}
}
