/// <summary> /// 修改 /// </summary> /// <param name="entity"></param> /// <param name="ApplicationId"></param> /// <returns></returns> public AjaxResult Update(C_S_Application entity, string ApplicationId) { AjaxResult msg = new AjaxResult(); string sqlStr = @"UPDATE dbo.C_S_Application SET ApplicationName = @ApplicationName, ApplicationCode = @ApplicationCode, SortCode = @SortCode, Company = @Company, Remark = @Remark, UpdateBy = @UpdateBy, UpdateTime = @UpdateTime, StartFileName = @StartFileName WHERE ApplicationId = @ApplicationId"; SqlParameter[] parameter = { new SqlParameter("ApplicationId", entity.ApplicationId), new SqlParameter("ApplicationName", entity.ApplicationName), new SqlParameter("ApplicationCode", entity.ApplicationCode), new SqlParameter("SortCode", entity.SortCode), new SqlParameter("Company", entity.Company), new SqlParameter("Remark", entity.Remark), new SqlParameter("UpdateBy", entity.UpdateBy), new SqlParameter("UpdateTime", entity.UpdateTime), new SqlParameter("StartFileName", entity.StartFileName), }; int result = SqlHelper.ExecuteNonQuery(sqlStr, parameter); if (result == 1) { msg.data = ""; msg.state = "success"; msg.message = "修改成功!"; } else { msg.data = ""; msg.state = "error"; msg.message = "修改失败!"; } return(msg); }
/// <summary> /// 新增 /// </summary> /// <param name="entity"></param> /// <returns></returns> public AjaxResult Add(C_S_Application entity) { AjaxResult msg = new AjaxResult(); List <SqlParameter> parameter = new List <SqlParameter>(); parameter.Add(new SqlParameter("ApplicationName", entity.ApplicationName)); parameter.Add(new SqlParameter("ApplicationCode", entity.ApplicationCode)); parameter.Add(new SqlParameter("Company", entity.Company)); string sqlStr = "select * from C_S_Application where (ApplicationName = @ApplicationName or ApplicationCode=@ApplicationCode) and Company = @Company"; DataTable dt = SqlHelper.ExecuteDataTable(sqlStr, parameter.ToArray()); if (dt.Rows.Count > 0) { msg.data = ""; msg.state = "error"; msg.message = "新增失败,该应用已经存在!"; } else { sqlStr = @"INSERT INTO dbo.C_S_Application (ApplicationId,ApplicationName,ApplicationCode, Company,SortCode,Remark,CreateBy,CreateTime,StartFileName) VALUES ( @ApplicationId ,@ApplicationName , @ApplicationCode , @Company, @SortCode , @Remark , @CreateBy , @CreateTime,@StartFileName) "; parameter.Clear(); parameter.Add(new SqlParameter("ApplicationId", entity.ApplicationId)); parameter.Add(new SqlParameter("ApplicationName", entity.ApplicationName)); parameter.Add(new SqlParameter("ApplicationCode", entity.ApplicationCode)); parameter.Add(new SqlParameter("SortCode", entity.SortCode)); parameter.Add(new SqlParameter("Company", entity.Company)); parameter.Add(new SqlParameter("Remark", entity.ApplicationName)); parameter.Add(new SqlParameter("CreateBy", entity.CreateBy)); parameter.Add(new SqlParameter("CreateTime", entity.CreateTime)); parameter.Add(new SqlParameter("StartFileName", entity.StartFileName)); int result = SqlHelper.ExecuteNonQuery(sqlStr, parameter.ToArray()); if (result == 1) { msg.data = ""; msg.state = "success"; msg.message = "新增成功!"; #region =====================写操作日志====================== C_S_Log log = new C_S_Log() { OperateType = 4, //新增 OperateUserId = entity.CreateBy, ApplicationId = entity.ApplicationId, ApplicationCode = entity.ApplicationCode, Content = "新增应用", IPAddress = Net.Ip, MachineName = Net.Host }; CSLog_BLL.Add(log); #endregion ================================================= } else { msg.data = ""; msg.state = "error"; msg.message = "新增失败!"; } } return(msg); }