/// <summary> /// 删除 /// </summary> public override void EntityDelete() { CostRecordRule rule = new CostRecordRule(); CostRecord entity = EntityGet(); rule.RDelete(entity); }
/// <summary> /// 设置 /// </summary> public override void EntitySet() { CostRecord entity = new CostRecord(); entity.ID = HTDataID; bool findFlag = entity.SelectByID(); txtFormNo.Text = entity.FormNo.ToString(); txtFormDate.DateTime = entity.FormDate; drpVendorID.EditValue = entity.VendorID.ToString(); txtOrderFormNo.Text = entity.OrderFormNo.ToString(); drpCostType.EditValue = entity.CostType.ToString(); txtAmount.Text = entity.Amount.ToString(); txtRemark.Text = entity.Remark.ToString(); txtMakeOPID.Text = entity.MakeOPID.ToString(); txtMakeOPName.Text = entity.MakeOPName.ToString(); txtMakeDate.DateTime = entity.MakeDate; txtSinglePrice.Text = entity.SinglePrice.ToString(); txtQty.Text = entity.Qty.ToString(); txtCostContent.Text = entity.CostContent.ToString(); txtAidNo.Text = entity.AidNo.ToString(); txtUnit.Text = entity.Unit.ToString(); txtSJAmount.Text = entity.SJAmount.ToString(); txtInvoiceAmount.Text = entity.InvoiceAmount.ToString(); txtInvoiceBalance.Text = entity.InvoiceBalance.ToString(); txtInvoiceNo.Text = entity.InvoiceNo.ToString(); drpPayment.Text = SysConvert.ToString(entity.Payment); HTDataSubmitFlag = entity.SubmitFlag; HTDataDelFlag = entity.DelFlag; if (!findFlag) { } }
/// <summary> /// 获得实体 /// </summary> /// <returns></returns> private CostRecord EntityGet() { CostRecord entity = new CostRecord(); entity.ID = HTDataID; return(entity); }
/// <summary> /// 删除 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Delete(BaseEntity p_Entity) { try { CostRecord MasterEntity = (CostRecord)p_Entity; if (MasterEntity.ID == 0) { return(0); } //删除主表数据 string Sql = ""; Sql = "DELETE FROM Finance_CostRecord WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(Sql); } else { AffectedRows = sqlTrans.ExecuteNonQuery(Sql); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBDelete), E); } }
/// <summary> /// 获得实体 /// </summary> /// <returns></returns> private CostRecord EntityGet() { CostRecord entity = new CostRecord(); entity.ID = HTDataID; entity.SelectByID(); entity.FormNo = txtFormNo.Text.Trim(); entity.FormDate = txtFormDate.DateTime.Date; entity.VendorID = SysConvert.ToString(drpVendorID.EditValue); entity.OrderFormNo = txtOrderFormNo.Text.Trim(); entity.CostType = SysConvert.ToString(drpCostType.EditValue); entity.Remark = txtRemark.Text.Trim(); entity.SinglePrice = SysConvert.ToDecimal(txtSinglePrice.Text.Trim()); entity.Qty = SysConvert.ToDecimal(txtQty.Text.Trim()); entity.CostContent = txtCostContent.Text.Trim(); entity.Amount = SysConvert.ToDecimal(txtAmount.Text.Trim()); entity.AidNo = txtAidNo.Text.Trim(); entity.Unit = txtUnit.Text.Trim(); entity.SJAmount = SysConvert.ToDecimal(txtSJAmount.Text.Trim()); entity.InvoiceAmount = SysConvert.ToDecimal(txtInvoiceAmount.Text.Trim()); entity.InvoiceBalance = SysConvert.ToDecimal(txtInvoiceBalance.Text.Trim()); entity.InvoiceNo = txtInvoiceNo.Text.Trim(); entity.Payment = SysConvert.ToString(drpPayment.Text); if (HTFormStatus == FormStatus.新增) { entity.MakeOPID = FParamConfig.LoginID; entity.MakeOPName = FParamConfig.LoginName; entity.MakeDate = DateTime.Now.Date; } return(entity); }
/// <summary> /// 新增 /// </summary> public override int EntityAdd() { CostRecordRule rule = new CostRecordRule(); CostRecord entity = EntityGet(); rule.RAdd(entity); return(entity.ID); }
/// <summary> /// 检验字段值是否已存在 /// </summary> /// <param name="p_TableName">表名</param> /// <param name="p_FieldName">字段名</param> /// <param name="p_FieldValue">字段值</param> /// <param name="p_KeyField">主键(只考虑主键为ID的情况)</param> /// <param name="p_KeyValue">主键值</param> /// <param name="p_sqlTrans"></param> /// <returns></returns> private bool CheckFieldValueIsExist(BaseEntity p_BE, string p_FieldName, string p_FieldValue, IDBTransAccess p_sqlTrans) { CostRecord entity = (CostRecord)p_BE; bool ret = false; string sql = string.Format(" SELECT {0} FROM {1} WHERE 1=1 AND {0}={2} AND {3}<>{4}", p_FieldName, CostRecord.TableName, SysString.ToDBString(p_FieldValue), "ID", entity.ID); DataTable dt = p_sqlTrans.Fill(sql); if (dt.Rows.Count != 0) { ret = true; } return(ret); }
/// <summary> /// 删除 /// </summary> /// <param name="p_BE">要删除的实体</param> /// <param name="sqlTrans">事务类</param> public void RDelete(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); CostRecord entity = (CostRecord)p_BE; CostRecordCtl control = new CostRecordCtl(sqlTrans); control.Delete(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
public void AddCost(CostRecordEntity record) { var entity = new CostRecord() { RecordId = record.RecordId, DeptId = record.RecordDeptId, DeptName = record.RecordDept, Category = record.Category, BudgetAmount = record.BudgetAmount, RecordUserId = record.RecordUserId, RecordUser = record.RecordUser, RecordMonth = record.RecordMonth, RecordTime = record.RecordTime, Professional = record.professional, CostItems = record.CostItems.Select(x => new CostItem() { CostItemId = x.CostItemId, DeptId = x.DeptId, DeptName = x.DeptName, Amount = x.Amount }).ToList() }; var departmentservie = new DepartmentService(); var depts = departmentservie.GetSubDepartments(entity.DeptId, null).Select(x => x.DepartmentId).ToList(); var year = entity.RecordMonth.Year.ToString(); var month = entity.RecordMonth.Month.ToString(); using (var ctx = new DataContext()) { var cnt = ctx.CostRecords.Where(x => x.DeptId == entity.DeptId && x.Category == entity.Category && x.RecordMonth == entity.RecordMonth).Count(); if (cnt > 0) { throw new Exception("已经存在费用记录!"); } var ddd = ctx.Budgets.Include("BudgetItems").Where(x => x.Category == entity.Category && x.Year == year).ToList(); ddd = ddd.Where(x => depts.Any(y => y == x.DeptId)).ToList(); var sss = ddd.SelectMany(x => x.BudgetItems).Where(x => x.Month == month); entity.BudgetAmount = sss.Sum(x => x.Amount); ctx.CostRecords.Add(entity); ctx.SaveChanges(); } }
/// <summary> /// 新增(传入事务处理) /// </summary> /// <param name="p_BE">要新增的实体</param> /// <param name="sqlTrans">事务类</param> public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans) { try { this.CheckCorrect(p_BE); CostRecord entity = (CostRecord)p_BE; CostRecordCtl control = new CostRecordCtl(sqlTrans); entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Finance_CostRecord, sqlTrans); control.AddNew(entity); } catch (BaseException) { throw; } catch (Exception E) { throw new BaseException(E.Message); } }
/// <summary> /// 通过会员ID,产品ID和金额修改消费记录 /// </summary> /// <param name="memID">会员ID</param> /// <param name="pdID">产品ID</param> /// <param name="money">金额</param> /// <returns></returns> public int RecordCost(int memID, int pdID, float money) { PdInfoMaintain pim = new PdInfoMaintain(); DataSet ds = pim.GetPdInfoByPdID(pdID); CostRecord cr = new CostRecord(); cr.CostTime = DateTime.Now; cr.MemID = memID; cr.MerID = Convert.ToInt32(ds.Tables[0].Rows[0]["mer_id"].ToString()); cr.CostMoney = money; cr.PdID = pdID; cr.PdName = ds.Tables[0].Rows[0]["pd_name"].ToString(); dbc = new DBConnection(); strSql = @"INSERT INTO [shuaka].[dbo].[cost_record] ([mem_id] ,[mer_id] ,[cost_time] ,[cost_money] ,[pd_id] ,[pd_name]) VALUES (@MemID, @MerID, @CostTime, @CostMoney, @PdID, @PdName)"; SqlParameter[] paras = { new SqlParameter("MemID", cr.MemID), new SqlParameter("MerID", cr.MerID), new SqlParameter("CostTime", DateTime.Now), new SqlParameter("CostMoney", cr.CostMoney), new SqlParameter("PdID", cr.PdID), new SqlParameter("PdName", cr.PdName), }; return(dbc.Execute(strSql, paras)); }
/// <summary> /// 新增 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int AddNew(BaseEntity p_Entity) { try { CostRecord MasterEntity = (CostRecord)p_Entity; if (MasterEntity.ID == 0) { return(0); } //新增主表数据 StringBuilder MasterField = new StringBuilder(); StringBuilder MasterValue = new StringBuilder(); MasterField.Append("INSERT INTO Finance_CostRecord("); MasterValue.Append(" VALUES("); MasterField.Append("ID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.ID) + ","); MasterField.Append("FormNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.FormNo) + ","); MasterField.Append("FormDate" + ","); if (MasterEntity.FormDate != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.FormDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("VendorID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.VendorID) + ","); MasterField.Append("OrderFormNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.OrderFormNo) + ","); MasterField.Append("CostType" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CostType) + ","); MasterField.Append("Amount" + ","); if (MasterEntity.Amount != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.Amount) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("Remark" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Remark) + ","); MasterField.Append("SubmitFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.SubmitFlag) + ","); MasterField.Append("DelFlag" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.DelFlag) + ","); MasterField.Append("MakeOPID" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.MakeOPID) + ","); MasterField.Append("MakeOPName" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.MakeOPName) + ","); MasterField.Append("MakeDate" + ","); if (MasterEntity.MakeDate != SystemConfiguration.DateTimeDefaultValue) { MasterValue.Append(SysString.ToDBString(MasterEntity.MakeDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("SinglePrice" + ","); if (MasterEntity.SinglePrice != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.SinglePrice) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("Qty" + ","); if (MasterEntity.Qty != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.Qty) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("CostContent" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.CostContent) + ","); MasterField.Append("InvoiceNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.InvoiceNo) + ","); MasterField.Append("InvoiceAmount" + ","); if (MasterEntity.InvoiceAmount != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.InvoiceAmount) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("AidNo" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.AidNo) + ","); MasterField.Append("InvoiceBalance" + ","); if (MasterEntity.InvoiceBalance != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.InvoiceBalance) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("Unit" + ","); MasterValue.Append(SysString.ToDBString(MasterEntity.Unit) + ","); MasterField.Append("SJAmount" + ","); if (MasterEntity.SJAmount != 0) { MasterValue.Append(SysString.ToDBString(MasterEntity.SJAmount) + ","); } else { MasterValue.Append("null,"); } MasterField.Append("Payment" + ")"); MasterValue.Append(SysString.ToDBString(MasterEntity.Payment) + ")"); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString()); } else { AffectedRows = sqlTrans.ExecuteNonQuery(MasterField.Append(MasterValue.ToString()).ToString()); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBInsert), E); } }
/// <summary> /// 修改 /// </summary> /// <param name="p_Entity">实体类</param> /// <returns>操作影响的记录行数</returns> public override int Update(BaseEntity p_Entity) { try { CostRecord MasterEntity = (CostRecord)p_Entity; if (MasterEntity.ID == 0) { return(0); } //更新主表数据 StringBuilder UpdateBuilder = new StringBuilder(); UpdateBuilder.Append("UPDATE Finance_CostRecord SET "); UpdateBuilder.Append(" ID=" + SysString.ToDBString(MasterEntity.ID) + ","); UpdateBuilder.Append(" FormNo=" + SysString.ToDBString(MasterEntity.FormNo) + ","); if (MasterEntity.FormDate != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" FormDate=" + SysString.ToDBString(MasterEntity.FormDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" FormDate=null,"); } UpdateBuilder.Append(" VendorID=" + SysString.ToDBString(MasterEntity.VendorID) + ","); UpdateBuilder.Append(" OrderFormNo=" + SysString.ToDBString(MasterEntity.OrderFormNo) + ","); UpdateBuilder.Append(" CostType=" + SysString.ToDBString(MasterEntity.CostType) + ","); if (MasterEntity.Amount != 0) { UpdateBuilder.Append(" Amount=" + SysString.ToDBString(MasterEntity.Amount) + ","); } else { UpdateBuilder.Append(" Amount=null,"); } UpdateBuilder.Append(" Remark=" + SysString.ToDBString(MasterEntity.Remark) + ","); UpdateBuilder.Append(" SubmitFlag=" + SysString.ToDBString(MasterEntity.SubmitFlag) + ","); UpdateBuilder.Append(" DelFlag=" + SysString.ToDBString(MasterEntity.DelFlag) + ","); UpdateBuilder.Append(" MakeOPID=" + SysString.ToDBString(MasterEntity.MakeOPID) + ","); UpdateBuilder.Append(" MakeOPName=" + SysString.ToDBString(MasterEntity.MakeOPName) + ","); if (MasterEntity.MakeDate != SystemConfiguration.DateTimeDefaultValue) { UpdateBuilder.Append(" MakeDate=" + SysString.ToDBString(MasterEntity.MakeDate.ToString("yyyy-MM-dd HH:mm:ss")) + ","); } else { UpdateBuilder.Append(" MakeDate=null,"); } if (MasterEntity.SinglePrice != 0) { UpdateBuilder.Append(" SinglePrice=" + SysString.ToDBString(MasterEntity.SinglePrice) + ","); } else { UpdateBuilder.Append(" SinglePrice=null,"); } if (MasterEntity.Qty != 0) { UpdateBuilder.Append(" Qty=" + SysString.ToDBString(MasterEntity.Qty) + ","); } else { UpdateBuilder.Append(" Qty=null,"); } UpdateBuilder.Append(" CostContent=" + SysString.ToDBString(MasterEntity.CostContent) + ","); UpdateBuilder.Append(" InvoiceNo=" + SysString.ToDBString(MasterEntity.InvoiceNo) + ","); if (MasterEntity.InvoiceAmount != 0) { UpdateBuilder.Append(" InvoiceAmount=" + SysString.ToDBString(MasterEntity.InvoiceAmount) + ","); } else { UpdateBuilder.Append(" InvoiceAmount=null,"); } UpdateBuilder.Append(" AidNo=" + SysString.ToDBString(MasterEntity.AidNo) + ","); if (MasterEntity.InvoiceBalance != 0) { UpdateBuilder.Append(" InvoiceBalance=" + SysString.ToDBString(MasterEntity.InvoiceBalance) + ","); } else { UpdateBuilder.Append(" InvoiceBalance=null,"); } UpdateBuilder.Append(" Unit=" + SysString.ToDBString(MasterEntity.Unit) + ","); if (MasterEntity.SJAmount != 0) { UpdateBuilder.Append(" SJAmount=" + SysString.ToDBString(MasterEntity.SJAmount) + ","); } else { UpdateBuilder.Append(" SJAmount=null,"); } UpdateBuilder.Append(" Payment=" + SysString.ToDBString(MasterEntity.Payment)); UpdateBuilder.Append(" WHERE " + "ID=" + SysString.ToDBString(MasterEntity.ID)); //执行 int AffectedRows = 0; if (!this.sqlTransFlag) { AffectedRows = this.ExecuteNonQuery(UpdateBuilder.ToString()); } else { AffectedRows = sqlTrans.ExecuteNonQuery(UpdateBuilder.ToString()); } return(AffectedRows); } catch (BaseException E) { throw new BaseException(E.Message, E); } catch (Exception E) { throw new BaseException(FrameWorkMessage.GetAlertMessage((int)Message.CommonDBUpdate), E); } }
/// <summary> /// 检查将要操作的数据是否符合业务规则 /// </summary> /// <param name="p_BE"></param> private void CheckCorrect(BaseEntity p_BE) { CostRecord entity = (CostRecord)p_BE; }