public bool Exists(Common_DictModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from Common_Dict");
builder.AppendFormat(" where Common_Dict_ID<>'{0}'and D_Name='{1}' and D_Type='{2}' ", model.Common_Dict_ID, model.D_Name, model.D_Type);
return(int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0);
}
internal int Update(DbTransaction tran, Common_DictModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" UPDATE ");
builder.Append(" Common_Dict ");
builder.Append(" SET ");
builder.Append(" Common_Dict_ID=@Common_Dict_ID,D_Name=@D_Name,D_ParentID=@D_ParentID,D_Value=@D_Value,D_Code=@D_Code,D_Order=@D_Order,D_Type=@D_Type,D_Remark=@D_Remark,D_CreateUser=@D_CreateUser,D_CreateTime=@D_CreateTime,D_ModifyUser=@D_ModifyUser,D_ModifyTime=@D_ModifyTime ");
builder.Append(" WHERE ");
builder.Append(" Common_Dict_ID=@Common_Dict_ID ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.Common_Dict_ID, model.D_Name, model.D_ParentID, model.D_Value, model.D_Code, model.D_Order, model.D_Type, model.D_Remark, model.D_CreateUser, model.D_CreateTime, model.D_ModifyUser, model.D_ModifyTime }));
}
internal int Add(DbTransaction tran, Common_DictModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" INSERT INTO ");
builder.Append(" Common_Dict( ");
builder.Append(" Common_Dict_ID,D_Name,D_ParentID,D_Value,D_Code,D_Order,D_Type,D_Remark,D_CreateUser,D_CreateTime,D_ModifyUser,D_ModifyTime ");
builder.Append(" ) ");
builder.Append(" values( ");
builder.Append(" @Common_Dict_ID,@D_Name,@D_ParentID,@D_Value,@D_Code,@D_Order,@D_Type,@D_Remark,@D_CreateUser,@D_CreateTime,@D_ModifyUser,@D_ModifyTime ");
builder.Append(" ) ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.Common_Dict_ID, model.D_Name, model.D_ParentID, model.D_Value, model.D_Code, model.D_Order, model.D_Type, model.D_Remark, model.D_CreateUser, model.D_CreateTime, model.D_ModifyUser, model.D_ModifyTime }));
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (CheckInput())
{
Common_DictModel model = new Common_DictModel();
model = GetData();
bool result = false;
if (string.IsNullOrEmpty(common_dict_id))//添加
{
if (bll.Exists(model, 1))
{
ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.div_PopEdit('2','已存在同名数据更新项！');</script>");
return;
}
else
{
result = bll.Add(model) > 0 ? true : false;
}
}
else//修改
{
if (bll.Exists(model, 2))
{
ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.div_PopEdit('2','已存在同名数据更新项！');</script>");
return;
}
else
{
result = bll.Update(model) > 0 ? true : false;
}
}
if (result)
{
ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.div_PopEdit('1','保存成功！','" + model.Common_Dict_ID + "');</script>");
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.div_PopEdit('2','保存失败！');</script>");
}
}
}
catch (Exception ex)
{
new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类：{0}，方法：{1},错误信息：{2}， 详细：{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
throw ex;
}
}
public bool Exists(Common_DictModel model, int type)
{
StringBuilder builder = new StringBuilder();
builder.Append("select count(1) from Common_Dict");
if (type == 1)
{
builder.AppendFormat(" where (D_Name='{0}' or D_Remark='{1}') and D_Type='{2}'", model.D_Name, model.D_Remark, model.D_Type);
}
else
{
builder.AppendFormat(" where Common_Dict_ID<>'{0}' and D_Type='{1}' and (D_Remark='{2}' or D_Name='{3}') ", new object[] { model.Common_Dict_ID, model.D_Type, model.D_Remark, model.D_Name });
}
return(int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0);
}
//获取界面参数
private Common_DictModel GetData()
{
Common_DictModel model = new Common_DictModel();
if (string.IsNullOrEmpty(common_dict_id))
{
model.Common_Dict_ID = Guid.NewGuid().ToString();
model.D_CreateUser = loginUser.SysUser_ID;
model.D_CreateTime = DateTime.Now;
}
else
{
model = new Common_DictBLL().GetCommon_DictModelByPK(common_dict_id);
model.D_ModifyTime = DateTime.Now;
model.D_ModifyUser = loginUser.SysUser_ID;
}
model.D_Name = txtd_name.Text.Trim();
model.D_Code = txtD_code.Text.Trim();
model.D_Remark = txtd_Remark.Text.Trim();
model.D_Type = 43;
return(model);
}
//从页面上获取模板数据
private Common_DictModel GetSysCodeFromPage(int i)
{
Common_DictModel Common_DictTemp = null;
if (i == 1)
{
Common_DictTemp = new Common_DictModel();
Common_DictTemp.Common_Dict_ID = Guid.NewGuid().ToString();
Common_DictTemp.D_CreateUser = loginUser.SysUser_ID;
Common_DictTemp.D_CreateTime = DateTime.Now;
}
else
{
Common_DictTemp = new Common_DictModel();
Common_DictTemp.Common_Dict_ID = sysCommon_Dict_ID;
Common_DictTemp.D_ModifyUser = loginUser.SysUser_ID;
Common_DictTemp.D_ModifyTime = DateTime.Now;
}
Common_DictTemp.D_Name = txtD_Name.Text.Trim();
if (!string.IsNullOrEmpty(txtD_Value.Text.Trim()))
{
Common_DictTemp.D_Value = int.Parse(txtD_Value.Text.Trim());
}
//Common_DictTemp.D_Code = txtD_Code.Text.Trim();
if (!string.IsNullOrEmpty(txtD_Order.Text.Trim()))
{
Common_DictTemp.D_Order = int.Parse(txtD_Order.Text.Trim());
}
if (!string.IsNullOrEmpty(ddlD_Type.SelectedValue.Trim()))
{
Common_DictTemp.D_Type = int.Parse(ddlD_Type.SelectedValue.Trim());
}
Common_DictTemp.D_Remark = txtRemark.Text.Trim();
return(Common_DictTemp);
}
public bool Exists(Common_DictModel model)
{
return(this.DAL.Exists(model));
}
public bool Exists(Common_DictModel model, int type)
{
return(this.DAL.Exists(model, type));
}
public int Update(Common_DictModel model)
{
return(this.DAL.Update(model));
}
public int Add(Common_DictModel model)
{
return(this.DAL.Add(model));
}
internal Common_DictModel GetCommon_DictModelByPK(DbTransaction tran, string common_dict_id)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
builder.Append(" TOP 1 * ");
builder.Append(" FROM ");
builder.Append(" Common_Dict ");
builder.Append(" WHERE ");
builder.Append(" Common_Dict_ID=@Common_Dict_ID ");
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, new object[] { common_dict_id });
Common_DictModel model = null;
if (set.Tables[0].Rows.Count > 0)
{
DataRow row = set.Tables[0].Rows[0];
model = new Common_DictModel();
if (row["Common_Dict_ID"] != null)
{
model.Common_Dict_ID = row["Common_Dict_ID"].ToString();
}
if (row["D_Name"] != null)
{
model.D_Name = row["D_Name"].ToString();
}
if (row["D_ParentID"] != null)
{
model.D_ParentID = row["D_ParentID"].ToString();
}
if (row["D_Value"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Value"].ToString()))
{
model.D_Value = null;
}
else
{
model.D_Value = new int?(int.Parse(row["D_Value"].ToString()));
}
}
if (row["D_Code"] != null)
{
model.D_Code = row["D_Code"].ToString();
}
if (row["D_Order"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Order"].ToString()))
{
model.D_Order = null;
}
else
{
model.D_Order = new int?(int.Parse(row["D_Order"].ToString()));
}
}
if (row["D_Type"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Type"].ToString()))
{
model.D_Type = null;
}
else
{
model.D_Type = new int?(int.Parse(row["D_Type"].ToString()));
}
}
if (row["D_Remark"] != null)
{
model.D_Remark = row["D_Remark"].ToString();
}
if (row["D_CreateUser"] != null)
{
model.D_CreateUser = row["D_CreateUser"].ToString();
}
if (row["D_CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString()))
{
model.D_CreateTime = null;
}
else
{
model.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString()));
}
}
if (row["D_ModifyUser"] != null)
{
model.D_ModifyUser = row["D_ModifyUser"].ToString();
}
if (row["D_ModifyTime"] == null)
{
return(model);
}
if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString()))
{
model.D_ModifyTime = null;
return(model);
}
model.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString()));
}
return(model);
}
//验证编辑是否存在
private bool Exists(Common_DictModel model)
{
return(BLL.Exists(model));
}
public int Add(Common_DictModel model)
{
return(this.Add(null, model));
}
internal List <Common_DictModel> GetCommon_DictModelList(DbTransaction tran, int recordNum, string orderColumn, string orderType, string strCondition, params object[] param)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
if (recordNum > 0)
{
builder.Append(" TOP " + recordNum);
}
builder.Append(" * ");
builder.Append(" FROM ");
builder.Append(" Common_Dict ");
if (!string.IsNullOrEmpty(strCondition))
{
builder.Append(" WHERE ");
builder.Append(strCondition);
}
if (!string.IsNullOrEmpty(orderColumn))
{
builder.Append(" ORDER BY ");
builder.Append(orderColumn);
if (!string.IsNullOrEmpty(orderType))
{
builder.Append(" " + orderType);
}
}
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param);
List <Common_DictModel> list = new List <Common_DictModel>();
Common_DictModel item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Common_DictModel();
if (row["Common_Dict_ID"] != null)
{
item.Common_Dict_ID = row["Common_Dict_ID"].ToString();
}
if (row["D_Name"] != null)
{
item.D_Name = row["D_Name"].ToString();
}
if (row["D_ParentID"] != null)
{
item.D_ParentID = row["D_ParentID"].ToString();
}
if (row["D_Value"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Value"].ToString()))
{
item.D_Value = null;
}
else
{
item.D_Value = new int?(int.Parse(row["D_Value"].ToString()));
}
}
if (row["D_Code"] != null)
{
item.D_Code = row["D_Code"].ToString();
}
if (row["D_Order"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Order"].ToString()))
{
item.D_Order = null;
}
else
{
item.D_Order = new int?(int.Parse(row["D_Order"].ToString()));
}
}
if (row["D_Type"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Type"].ToString()))
{
item.D_Type = null;
}
else
{
item.D_Type = new int?(int.Parse(row["D_Type"].ToString()));
}
}
if (row["D_Remark"] != null)
{
item.D_Remark = row["D_Remark"].ToString();
}
if (row["D_CreateUser"] != null)
{
item.D_CreateUser = row["D_CreateUser"].ToString();
}
if (row["D_CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString()))
{
item.D_CreateTime = null;
}
else
{
item.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString()));
}
}
if (row["D_ModifyUser"] != null)
{
item.D_ModifyUser = row["D_ModifyUser"].ToString();
}
if (row["D_ModifyTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString()))
{
item.D_ModifyTime = null;
}
else
{
item.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString()));
}
}
list.Add(item);
}
return(list);
}
//验证添加是否存在
private bool SysCommon_DictExists(Common_DictModel model)
{
return(BLL.SysCommon_DictExists(model));
}
public int Update(Common_DictModel model)
{
return(this.Update(null, model));
}
internal List <Common_DictModel> GetCommon_DictModelListByPage(DbTransaction tran, int pageSize, int pageIndex, string orderColumn, string orderType, string strCondition, params object[] param)
{
if ((pageSize <= 0) || (pageIndex <= 0))
{
throw new Exception("分页参数错误，必须大于零");
}
if (string.IsNullOrEmpty(orderColumn))
{
throw new Exception("排序字段必须填写");
}
int num = ((pageIndex - 1) * pageSize) + 1;
int num2 = pageIndex * pageSize;
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT * FROM (");
builder.Append(string.Format(" SELECT (ROW_NUMBER() OVER(ORDER BY {0} {1})) as rownum,* FROM Common_Dict", orderColumn, orderType));
if (!string.IsNullOrWhiteSpace(strCondition))
{
builder.Append(" WHERE ");
builder.Append(strCondition);
}
builder.Append(" ) t ");
builder.Append(" WHERE rownum between ");
builder.Append(string.Format(" {0} ", num));
builder.Append(" AND ");
builder.Append(string.Format(" {0} ", num2));
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param);
List <Common_DictModel> list = new List <Common_DictModel>();
Common_DictModel item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Common_DictModel();
if (row["Common_Dict_ID"] != null)
{
item.Common_Dict_ID = row["Common_Dict_ID"].ToString();
}
if (row["D_Name"] != null)
{
item.D_Name = row["D_Name"].ToString();
}
if (row["D_ParentID"] != null)
{
item.D_ParentID = row["D_ParentID"].ToString();
}
if (row["D_Value"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Value"].ToString()))
{
item.D_Value = null;
}
else
{
item.D_Value = new int?(int.Parse(row["D_Value"].ToString()));
}
}
if (row["D_Code"] != null)
{
item.D_Code = row["D_Code"].ToString();
}
if (row["D_Order"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Order"].ToString()))
{
item.D_Order = null;
}
else
{
item.D_Order = new int?(int.Parse(row["D_Order"].ToString()));
}
}
if (row["D_Type"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_Type"].ToString()))
{
item.D_Type = null;
}
else
{
item.D_Type = new int?(int.Parse(row["D_Type"].ToString()));
}
}
if (row["D_Remark"] != null)
{
item.D_Remark = row["D_Remark"].ToString();
}
if (row["D_CreateUser"] != null)
{
item.D_CreateUser = row["D_CreateUser"].ToString();
}
if (row["D_CreateTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_CreateTime"].ToString()))
{
item.D_CreateTime = null;
}
else
{
item.D_CreateTime = new DateTime?(DateTime.Parse(row["D_CreateTime"].ToString()));
}
}
if (row["D_ModifyUser"] != null)
{
item.D_ModifyUser = row["D_ModifyUser"].ToString();
}
if (row["D_ModifyTime"] != null)
{
if (string.IsNullOrWhiteSpace(row["D_ModifyTime"].ToString()))
{
item.D_ModifyTime = null;
}
else
{
item.D_ModifyTime = new DateTime?(DateTime.Parse(row["D_ModifyTime"].ToString()));
}
}
list.Add(item);
}
return(list);
}
