/// <summary>
/// 修改系统预设信息
/// </summary>
/// <param name="sys"></param>
/// <returns></returns>
public int UpdateSys(SysPreinstallModel model)
{
StringBuilder sql = new StringBuilder();
sql.Append(@"UPDATE tbl_SysPreinstAll
SET
TabName = @TabName
,Comment = @Comment
,TableName = @TableName
,OptionName = @OptionName
,ChinName = @ChinName
,Content = @Content
,Compare = @Compare
,ImgPath = @ImgPath
,Width = @Width
,Height = @Height
,Seq = @Seq
,Text = @Text
WHERE ID = @ID");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@TabName", MySqlDbType.String, 50),
new MySqlParameter("@Comment", MySqlDbType.String, 50),
new MySqlParameter("@TableName", MySqlDbType.String, 50),
new MySqlParameter("@OptionName", MySqlDbType.String, 50),
new MySqlParameter("@ChinName", MySqlDbType.String, 50),
new MySqlParameter("@Content", MySqlDbType.String, 255),
new MySqlParameter("@Compare", MySqlDbType.String, 255),
new MySqlParameter("@ImgPath", MySqlDbType.String, 255),
new MySqlParameter("@Width", MySqlDbType.Int32),
new MySqlParameter("@Height", MySqlDbType.Int32),
new MySqlParameter("@Seq", MySqlDbType.Int32),
new MySqlParameter("@Text", MySqlDbType.String, 255),
new MySqlParameter("@ID", MySqlDbType.Int32)
};
cmdParms[0].Value = model.TabName;
cmdParms[1].Value = model.Comment;
cmdParms[2].Value = model.TableName;
cmdParms[3].Value = model.OptionName;
cmdParms[4].Value = model.ChinName;
cmdParms[5].Value = model.Content;
cmdParms[6].Value = model.Compare;
cmdParms[7].Value = model.ImgPath;
cmdParms[8].Value = model.Width;
cmdParms[9].Value = model.Height;
cmdParms[10].Value = model.Seq;
cmdParms[11].Value = model.Text;
cmdParms[12].Value = model.ID;
return(MySQLHelper.ExecuteSql(sql.ToString(), cmdParms));
}
/// <summary>
/// 修改系统预设信息
/// </summary>
/// <param name="sys"></param>
/// <returns></returns>
public int UpdateSys(SysPreinstallModel sys)
{
return(dal.UpdateSys(sys));
}
/// <summary>
/// 添加系统预设信息
/// </summary>
/// <param name="sys"></param>
/// <returns></returns>
public int InsertSys(SysPreinstallModel sys)
{
return(dal.InsertSys(sys));
}
/// <summary>
/// 添加系统预设信息
/// </summary>
/// <param name="sys"></param>
/// <returns></returns>
public int InsertSys(SysPreinstallModel model)
{
string sql = @"INSERT INTO tbl_SysPreinstAll
(
TabName
,Comment
,TableName
,OptionName
,ChinName
,Content
,RemarksCut
,Compare
,ImgPath
,Seq
,Text
,Separa
,Height
,Type
,Width
,Col2
,Col3
)
VALUES
(
@TabName
,@Comment
,@TableName
,@OptionName
,@ChinName
,@Content
,@RemarksCut
,@Compare
,@ImgPath
,@Seq
,@Text
,@Separa
,@Height
,@Type
,@Width
,@Col2
,@Col3
) ;SELECT @@IDENTITY";
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@TabName", MySqlDbType.String, 50),
new MySqlParameter("@Comment", MySqlDbType.String, 50),
new MySqlParameter("@TableName", MySqlDbType.String, 50),
new MySqlParameter("@OptionName", MySqlDbType.String, 50),
new MySqlParameter("@ChinName", MySqlDbType.String, 50),
new MySqlParameter("@Content", MySqlDbType.String, 255),
new MySqlParameter("@RemarksCut", MySqlDbType.String, 50),
new MySqlParameter("@Compare", MySqlDbType.String, 50),
new MySqlParameter("@ImgPath", MySqlDbType.String, 255),
new MySqlParameter("@Seq", MySqlDbType.Int32),
new MySqlParameter("@Text", MySqlDbType.String, 255),
new MySqlParameter("@Separa", MySqlDbType.String, 50),
new MySqlParameter("@Height", MySqlDbType.String, 50),
new MySqlParameter("@Type", MySqlDbType.String, 2),
new MySqlParameter("@Width", MySqlDbType.String, 50),
new MySqlParameter("@Col2", MySqlDbType.String, 100),
new MySqlParameter("@Col3", MySqlDbType.String, 100)
};
cmdParms[0].Value = model.TabName;
cmdParms[1].Value = model.Comment;
cmdParms[2].Value = model.TableName;
cmdParms[3].Value = model.OptionName;
cmdParms[4].Value = model.ChinName;
cmdParms[5].Value = model.Content;
cmdParms[6].Value = model.RemarksCut;
cmdParms[7].Value = model.Compare;
cmdParms[8].Value = model.ImgPath;
cmdParms[9].Value = model.Seq;
cmdParms[10].Value = model.Text;
cmdParms[11].Value = model.Separa;
cmdParms[12].Value = model.Height;
cmdParms[13].Value = model.Type;
cmdParms[14].Value = model.Width;
cmdParms[15].Value = model.Col2;
cmdParms[16].Value = model.Col3;
object single = MySQLHelper.GetSingle(sql, cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
