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