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