/// <summary> /// 插入一条新的数据,如果成功给Model.ID赋值主键,否则Model.ID="0" /// </summary> /// <param name="Model"></param> /// <returns></returns> public static bool InSert(InputCompanyRoyaltyModel Model) { StringBuilder strSql = new StringBuilder(); strSql.AppendLine("insert into officedba.InputCompanyRoyalty("); strSql.AppendLine("DeptID,CompanyCD,BusinessMoney,RecordDate,ModifiedUserID,CreateTime,ModifiedDate)"); strSql.AppendLine(" values ("); strSql.AppendLine("@DeptID,@CompanyCD,@BusinessMoney,@RecordDate,@ModifiedUserID,getdate(),getdate())"); strSql.AppendLine(";set @IndexID= @@IDENTITY"); SqlCommand comm = new SqlCommand(); comm.CommandText = strSql.ToString(); SqlParameter IndexID = new SqlParameter("@IndexID", SqlDbType.Int); IndexID.Direction = ParameterDirection.Output; comm.Parameters.Add(IndexID); SetSaveParameter(comm, Model); bool result = SqlHelper.ExecuteTransWithCommand(comm); if (result) { Model.ID = comm.Parameters["@IndexID"].Value.ToString(); } else { Model.ID = "0"; } return result; }
/// <summary> /// 查询公司提成录入信息 /// </summary> /// <returns>DataTable</returns> public static DataTable GetInfo(InputCompanyRoyaltyModel model, string timeStart, string timeEnd, int pageIndex, int pageCount, string ord, ref int TotalCount) { StringBuilder strSql = new StringBuilder(); strSql.AppendLine("SELECT a.ID "); strSql.AppendLine(",a.DeptID "); strSql.AppendLine(",b.DeptName "); strSql.AppendLine(",a.BusinessMoney "); strSql.AppendLine(",Convert(Varchar(10),a.RecordDate,21) as RecordDate "); strSql.AppendLine("FROM officedba.InputCompanyRoyalty a "); strSql.AppendLine("inner join officedba.DeptInfo b on a.DeptID=b.ID "); strSql.AppendLine("where a.CompanyCD=@CompanyCD "); SqlCommand comm = new SqlCommand(); //添加公司代码参数 comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD)); if (!string.IsNullOrEmpty(model.DeptID)) { strSql.AppendLine(" and a.DeptID = @DeptID"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID", model.DeptID)); } if (!string.IsNullOrEmpty(timeStart)) { strSql.AppendLine(" and a.RecordDate>=@timeStart"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@timeStart", timeStart)); } if (!string.IsNullOrEmpty(timeEnd)) { strSql.AppendLine(" and a.RecordDate<=@timeEnd"); comm.Parameters.Add(SqlHelper.GetParameterFromString("@timeEnd", Convert.ToDateTime(timeEnd).AddDays(1).ToString("yyyy-MM-dd"))); } comm.CommandText = strSql.ToString(); return SqlHelper.PagerWithCommand(comm, pageIndex, pageCount, ord, ref TotalCount); }
/// <summary> /// 查询公司提成录入信息 /// </summary> /// <returns>DataTable</returns> public static DataTable GetInfo(InputCompanyRoyaltyModel model, string timeStart, string timeEnd, int pageIndex, int pageCount, string ord, ref int TotalCount) { try { return InputCompanyRoyaltyDBHelper.GetInfo(model, timeStart, timeEnd, pageIndex, pageCount, ord, ref TotalCount); } catch (Exception) { throw; } }
/// <summary> /// 插入一条新的数据,如果成功给Model.ID赋值主键,否则Model.ID="0" /// </summary> /// <param name="Model"></param> /// <returns></returns> public static bool InSert(InputCompanyRoyaltyModel Model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ try { isSucc = InputCompanyRoyaltyDBHelper.InSert(Model); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(Model.DeptID); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return isSucc; }
/// <summary> /// 保存时基本信息参数设置 /// </summary> /// <param name="comm"></param> /// <param name="model"></param> private static void SetSaveParameter(SqlCommand comm, InputCompanyRoyaltyModel model) { if (!string.IsNullOrEmpty(model.ID)) { comm.Parameters.Add(SqlHelper.GetParameterFromString("@ID ", model.ID));//自动生成 } comm.Parameters.Add(SqlHelper.GetParameterFromString("@DeptID ", model.DeptID));//分公司ID comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD ", model.CompanyCD));//公司编码 comm.Parameters.Add(SqlHelper.GetParameterFromString("@BusinessMoney ", model.BusinessMoney));//数量 comm.Parameters.Add(SqlHelper.GetParameterFromString("@RecordDate ", model.RecordDate));//记录时间 comm.Parameters.Add(SqlHelper.GetParameterFromString("@ModifiedUserID ", model.ModifiedUserID));//最后更新人 }
/// <summary> /// 更新数据 /// </summary> /// <param name="Model"></param> /// <returns></returns> public static bool Update(InputCompanyRoyaltyModel Model) { StringBuilder strSql = new StringBuilder(); strSql.AppendLine("update officedba.InputCompanyRoyalty set "); strSql.AppendLine("DeptID=@DeptID,"); strSql.AppendLine("CompanyCD=@CompanyCD,"); strSql.AppendLine("BusinessMoney=@BusinessMoney,"); strSql.AppendLine("RecordDate=@RecordDate,"); strSql.AppendLine("ModifiedUserID=@ModifiedUserID,"); strSql.AppendLine("ModifiedDate=getdate()"); strSql.AppendLine(" where ID=@ID "); SqlCommand comm = new SqlCommand(strSql.ToString()); SetSaveParameter(comm, Model); return SqlHelper.ExecuteTransWithCommand(comm); }