public bool Update(Model_SysProduct model) { StringBuilder builder = new StringBuilder(); builder.Append("update SysProduct set "); builder.Append("SysName=@SysName,"); builder.Append("SysOrder=@SysOrder,"); builder.Append("SysURL=@SysURL,"); builder.Append("SysIcon=@SysIcon,"); builder.Append("Sys_CreateUser=@Sys_CreateUser,"); builder.Append("Sys_CreateTime=@Sys_CreateTime,"); builder.Append("Sys_UpdateUser=@Sys_UpdateUser,"); builder.Append("Sys_UpdateTime=@Sys_UpdateTime"); builder.Append(" where SysCode=@SysCode "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysName", SqlDbType.VarChar, 100), new SqlParameter("@SysOrder", SqlDbType.Int, 4), new SqlParameter("@SysURL", SqlDbType.VarChar, 500), new SqlParameter("@SysIcon", SqlDbType.VarChar, 100), new SqlParameter("@Sys_CreateUser", SqlDbType.NChar, 0x24), new SqlParameter("@Sys_CreateTime", SqlDbType.DateTime), new SqlParameter("@Sys_UpdateUser", SqlDbType.NChar, 0x24), new SqlParameter("@Sys_UpdateTime", SqlDbType.DateTime), new SqlParameter("@SysCode", SqlDbType.NChar, 5) }; cmdParms[0].Value = model.SysName; cmdParms[1].Value = model.SysOrder; cmdParms[2].Value = model.SysURL; cmdParms[3].Value = model.SysIcon; cmdParms[4].Value = model.Sys_CreateUser; cmdParms[5].Value = model.Sys_CreateTime; cmdParms[6].Value = model.Sys_UpdateUser; cmdParms[7].Value = model.Sys_UpdateTime; cmdParms[8].Value = model.SysCode; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
//从页面上获取模板数据 private Model_SysProduct GetSysProductFromPage() { var tempSysCode = txtSysCode.Text.Trim(); var tempName = txtSysProductName.Text.Trim(); var tempSort = txtSysProductSort.Text.Trim(); Model_SysProduct SysProductTemp = null; switch (actionType) { case SysProductType.Add: SysProductTemp = new Model_SysProduct(); SysProductTemp.Sys_CreateUser = loginUser.SysUser_ID; SysProductTemp.Sys_CreateTime = DateTime.Now; break; case SysProductType.Edit: SysProductTemp = new Model_SysProduct(); SysProductTemp.Sys_UpdateUser = loginUser.SysUser_ID; SysProductTemp.Sys_UpdateTime = DateTime.Now; break; } SysProductTemp.SysCode = tempSysCode; SysProductTemp.SysName = tempName; SysProductTemp.SysOrder = int.Parse(tempSort); return(SysProductTemp); }
public bool AddExists(Model_SysProduct model) { StringBuilder builder = new StringBuilder(); builder.Append("select count(1) from SysProduct"); builder.AppendFormat(" where SysCode='{0}'or SysName='{1}'", model.SysCode, model.SysName); return(int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0); }
public Model_SysProduct DataRowToModel(DataRow row) { Model_SysProduct product = new Model_SysProduct(); if (row != null) { if (row["SysCode"] != null) { product.SysCode = row["SysCode"].ToString(); } if (row["SysName"] != null) { product.SysName = row["SysName"].ToString(); } if ((row["SysOrder"] != null) && (row["SysOrder"].ToString() != "")) { product.SysOrder = new int?(int.Parse(row["SysOrder"].ToString())); } if (row["SysURL"] != null) { product.SysURL = row["SysURL"].ToString(); } if (row["SysIcon"] != null) { product.SysIcon = row["SysIcon"].ToString(); } if (row["Sys_CreateUser"] != null) { product.Sys_CreateUser = row["Sys_CreateUser"].ToString(); } if ((row["Sys_CreateTime"] != null) && (row["Sys_CreateTime"].ToString() != "")) { product.Sys_CreateTime = new DateTime?(DateTime.Parse(row["Sys_CreateTime"].ToString())); } if (row["Sys_UpdateUser"] != null) { product.Sys_UpdateUser = row["Sys_UpdateUser"].ToString(); } if ((row["Sys_UpdateTime"] != null) && (row["Sys_UpdateTime"].ToString() != "")) { product.Sys_UpdateTime = new DateTime?(DateTime.Parse(row["Sys_UpdateTime"].ToString())); } } return(product); }
public List <Model_SysProduct> DataTableToList(DataTable dt) { List <Model_SysProduct> list = new List <Model_SysProduct>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SysProduct item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(Model_SysProduct model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SysProduct("); builder.Append("SysCode,SysName,SysOrder,SysURL,SysIcon,Sys_CreateUser,Sys_CreateTime,Sys_UpdateUser,Sys_UpdateTime)"); builder.Append(" values ("); builder.Append("@SysCode,@SysName,@SysOrder,@SysURL,@SysIcon,@Sys_CreateUser,@Sys_CreateTime,@Sys_UpdateUser,@Sys_UpdateTime)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SysCode", SqlDbType.NChar, 5), new SqlParameter("@SysName", SqlDbType.VarChar, 100), new SqlParameter("@SysOrder", SqlDbType.Int, 4), new SqlParameter("@SysURL", SqlDbType.VarChar, 500), new SqlParameter("@SysIcon", SqlDbType.VarChar, 100), new SqlParameter("@Sys_CreateUser", SqlDbType.NChar, 0x24), new SqlParameter("@Sys_CreateTime", SqlDbType.DateTime), new SqlParameter("@Sys_UpdateUser", SqlDbType.NChar, 0x24), new SqlParameter("@Sys_UpdateTime", SqlDbType.DateTime) }; cmdParms[0].Value = model.SysCode; cmdParms[1].Value = model.SysName; cmdParms[2].Value = model.SysOrder; cmdParms[3].Value = model.SysURL; cmdParms[4].Value = model.SysIcon; cmdParms[5].Value = model.Sys_CreateUser; cmdParms[6].Value = model.Sys_CreateTime; cmdParms[7].Value = model.Sys_UpdateUser; cmdParms[8].Value = model.Sys_UpdateTime; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
//修改后验证是否存在 private bool AddExists(Model_SysProduct model) { return(BLL.AddExists(model)); }
//修改后验证是否存在 private bool EditExists(Model_SysProduct model) { return(BLL.EditExists(model)); }
public bool EditExists(Model_SysProduct model) { return(this.dal.EideExists(model)); }
public bool AddExists(Model_SysProduct model) { return(this.dal.AddExists(model)); }
public bool Update(Model_SysProduct model) { return(this.dal.Update(model)); }