public void LogCommonDataEditAction(CommonDataEditAction action)
{
LogDS logDS = new LogDS();
LogDS.CommonDataEditActionLogRow log = logDS.CommonDataEditActionLog.NewCommonDataEditActionLogRow();
log.ActionTime = action.ActionTime;
log.ActionType = action.ActionType;
log.DataTableName = action.DataTableName;
if (action.NewValue != null)
{
log.NewValue = action.NewValue;
}
if (action.OldValue != null)
{
log.OldValue = action.OldValue;
}
if (action.StuffId != null)
{
log.StuffId = action.StuffId;
}
log.StuffName = action.StuffName;
logDS.CommonDataEditActionLog.AddCommonDataEditActionLogRow(log);
this.CommonDataEditActionLogTA.Update(logDS.CommonDataEditActionLog);
}
public void UpdateShop(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string ShopName, int CustomerID, int ShopLevelID, string Address, string Contacter, string Tel, string Email, int ShopID, bool IsActive, string ShopNo)
{
// 检证"客户名称"唯一性
int iCount = (int)this.ShopAdapter.SearchNameByUpd(ShopName, ShopID, CustomerID, ShopLevelID);
if (iCount > 0) {
throw new ApplicationException("同一客户，同一门店等级下门店名称不能重复！");
}
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "更新";
action.DataTableName = "门店";
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
// 根据 ShopId 查找要修改的数据
ERS.ShopDataTable ShopTab = this.ShopAdapter.GetDataById(ShopID);
ERS.ShopRow ShopRow = ShopTab[0];
action.OldValue = "门店名称：" + ShopRow.ShopName;
ShopRow.ShopName = ShopName;
ShopRow.CustomerID = CustomerID;
ShopRow.ShopLevelID = ShopLevelID;
ShopRow.Address = Address;
ShopRow.Contacter = Contacter;
ShopRow.Tel = Tel;
ShopRow.Email = Email;
ShopRow.IsActive = IsActive;
ShopRow.ShopNo = ShopNo;
// 更新数据
this.ShopAdapter.Update(ShopRow);
action.NewValue = "门店名称：" + ShopRow.ShopName;
SysLog.LogCommonDataEditAction(action);
}
public void UpdateProvince(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int ProvinceID, string ProvinceName, bool IsActive)
{
int iCount = (int)this.ProvinceAdapter.SearchProvinceNameByUpd(ProvinceName, ProvinceID);
if (iCount > 0) {
throw new ApplicationException("省份名称重复");
}
CommonDataEditAction action = new CommonDataEditAction();
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
action.DataTableName = "省份";
action.ActionType = "更新";
action.ActionTime = DateTime.Now;
this.CityAdapter.DisabledCityByProvId(ProvinceID);
// 根据 CurrId 查找要修改的数据
ERS.ProvinceDataTable provTab = this.ProvinceAdapter.GetDataById(ProvinceID);
ERS.ProvinceRow provRow = provTab[0];
action.OldValue = "省份名称：" + provRow.ProvinceName;
provRow.ProvinceName = ProvinceName;
provRow.IsActive = IsActive;
this.ProvinceAdapter.Update(provRow);
action.NewValue = "省份名称：" + provRow.ProvinceName;
SysLog.LogCommonDataEditAction(action);
}
public void UpdateExpenseItem(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string ExpenseItemName, int ExpenseSubCategoryID, string AccountingName, string AccountingCode, Boolean IsInContract, Boolean IsActive, int ExpenseItemID)
{
// 检证"费用项"唯一性
int iCount = (int)this.ExpenseItemAdapter.SearchItemNameByUpd(ExpenseItemID, ExpenseItemName);
if (iCount > 0) {
throw new ApplicationException("在同一费用小类下，费用项名称不能重复！");
}
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "更新";
action.DataTableName = "费用项";
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
// 根据 ItemId 查找要修改的数据
ERS.ExpenseItemDataTable expenseItemTab = this.ExpenseItemAdapter.GetDataById(ExpenseItemID);
ERS.ExpenseItemRow expenseItemRow = expenseItemTab[0];
action.OldValue = "费用项名称：" + expenseItemRow.ExpenseItemName;
expenseItemRow.ExpenseItemName = ExpenseItemName;
expenseItemRow.AccountingCode = AccountingCode;
expenseItemRow.ExpenseSubCategoryID = ExpenseSubCategoryID;
expenseItemRow.AccountingName = AccountingName;
expenseItemRow.IsInContract = IsInContract;
expenseItemRow.IsActive = IsActive;
// 更新数据
this.ExpenseItemAdapter.Update(expenseItemRow);
action.NewValue = "费用项名称：" + expenseItemRow.ExpenseItemName;
SysLog.LogCommonDataEditAction(action);
}
public void UpdateCustomer(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string CustomerName, string CustomerNo, int CityID, int CustomerTypeID, int ChannelTypeID, int ApplyOrganizationUnitID, int OrganizationUnitID, Boolean IsActive, int CustomerID)
{
if (ApplyOrganizationUnitID <= 0) {
throw new ApplicationException("必须选择所属机构！");
}
if (OrganizationUnitID <= 0) {
throw new ApplicationException("必须选择所属预算机构！");
}
// 检证"客户名称"唯一性
int iCount = (int)this.CustomerAdapter.SearchNameByUpd(CustomerName, CustomerID);
if (iCount > 0) {
throw new ApplicationException("客户名称不能重复！");
}
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "更新";
action.DataTableName = "客户";
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
// 根据 CustId 查找要修改的数据
ERS.CustomerDataTable custTab = this.CustomerAdapter.GetDataById(CustomerID);
ERS.CustomerRow custRow = custTab[0];
action.OldValue = "客户名称：" + custRow.CustomerName;
custRow.CustomerName = CustomerName;
custRow.CustomerNo = CustomerNo;
custRow.CustomerTypeID = CustomerTypeID;
custRow.ChannelTypeID = ChannelTypeID;
custRow.CityID = CityID;
if (ApplyOrganizationUnitID > 0) {
custRow.ApplyOrganizationUnitID = ApplyOrganizationUnitID;
}
if (OrganizationUnitID > 0) {
custRow.OrganizationUnitID = OrganizationUnitID;
}
custRow.IsActive = IsActive;
// 更新数据
this.CustomerAdapter.Update(custRow);
action.NewValue = "客户名称：" + custRow.CustomerName;
SysLog.LogCommonDataEditAction(action);
}
public void UpdateCategory(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int ExpenseCategoryID, string ExpenseCategoryName, bool IsActive)
{
// 验证是否存在 ExpenseCategoryName 同名数据。
int iCount = (int)this.ExpenseCategoryAdapter.SearchCateByUpd(ExpenseCategoryName, ExpenseCategoryID);
if (iCount > 0) {
throw new ApplicationException("费用大类名称重名");
}
CommonDataEditAction action = new CommonDataEditAction();
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
action.DataTableName = "费用大类";
action.ActionType = "更新";
action.ActionTime = DateTime.Now;
this.ExpenseSubCategoryAdapter.DisabledExpenseSubCateByCateId(ExpenseCategoryID);
// 根据 CurrId 查找要修改的数据
ERS.ExpenseCategoryDataTable provTab = this.ExpenseCategoryAdapter.GetDataById(ExpenseCategoryID);
ERS.ExpenseCategoryRow provRow = provTab[0];
action.OldValue = "费用大类名称：" + provRow.ExpenseCategoryName;
provRow.ExpenseCategoryName = ExpenseCategoryName;
provRow.IsActive = IsActive;
this.ExpenseCategoryAdapter.Update(provRow);
action.NewValue = "费用大类名称：" + provRow.ExpenseCategoryName;
SysLog.LogCommonDataEditAction(action);
}
public static void LogCommonDataEditAction(CommonDataEditAction action)
{
SysTrace.TraceData(TraceEventType.Information, (int)LogType.CommonDateEdit, action);
}
public void InsertShop(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string ShopName, int CustomerID, int ShopLevelID, string Address, string Contacter, string Tel, string Email, bool IsActive, string ShopNo)
{
// 检证"门店名称"唯一性
int iCount = (int)this.ShopAdapter.SearchNameByIns(ShopName, CustomerID, ShopLevelID);
if (iCount > 0) {
throw new ApplicationException("同一客户，同一门店等级下门店名称不能重复！");
}
// 进行数据新增处理
ERS.ShopDataTable shopTab = new ERS.ShopDataTable();
ERS.ShopRow shopRow = shopTab.NewShopRow();
// 进行传值
shopRow.ShopName = ShopName;
shopRow.CustomerID = CustomerID;
shopRow.ShopLevelID = ShopLevelID;
shopRow.Address = Address;
shopRow.Contacter = Contacter;
shopRow.Tel = Tel;
shopRow.Email = Email;
shopRow.IsActive = IsActive;
shopRow.ShopNo = ShopNo;
// 填加行并进行更新处理
shopTab.AddShopRow(shopRow);
this.ShopAdapter.Update(shopTab);
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "添加";
action.DataTableName = "门店";
action.NewValue = "门店名称：" + shopRow.ShopName;
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
SysLog.LogCommonDataEditAction(action);
}
public void InsertExpenseItem(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string ExpenseItemName, int ExpenseSubCategoryID, string AccountingName, string AccountingCode, Boolean IsInContract, Boolean IsActive)
{
// 检证"费用项"唯一性
int iCount = (int)this.ExpenseItemAdapter.SearchItemNameByIns(ExpenseItemName);
if (iCount > 0) {
throw new ApplicationException("在同一费用小类下，费用项不能重复！");
}
// 进行数据新增处理
ERS.ExpenseItemDataTable subCateItemTab = new ERS.ExpenseItemDataTable();
ERS.ExpenseItemRow subCateItemRow = subCateItemTab.NewExpenseItemRow();
// 进行传值
subCateItemRow.ExpenseSubCategoryID = ExpenseSubCategoryID;
subCateItemRow.ExpenseItemName = ExpenseItemName;
subCateItemRow.AccountingName = AccountingName;
subCateItemRow.AccountingCode = AccountingCode;
subCateItemRow.IsInContract = IsInContract;
subCateItemRow.IsActive = IsActive;
// 填加行并进行更新处理
subCateItemTab.AddExpenseItemRow(subCateItemRow);
this.ExpenseItemAdapter.Update(subCateItemTab);
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "添加";
action.DataTableName = "费用项";
action.NewValue = "费用项名称：" + subCateItemRow.ExpenseItemName;
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
SysLog.LogCommonDataEditAction(action);
}
public void InsertProvince(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string ProvinceName, bool IsActive)
{
int iCount = (int)this.ProvinceAdapter.SearchProvinceNameByIns(ProvinceName);
if (iCount > 0) {
throw new ApplicationException("省份名称重复");
}
ERS.ProvinceDataTable currTab = new ERS.ProvinceDataTable();
ERS.ProvinceRow provRow = currTab.NewProvinceRow();
provRow.ProvinceName = ProvinceName;
provRow.IsActive = IsActive;
currTab.AddProvinceRow(provRow);
this.ProvinceAdapter.Update(currTab);
CommonDataEditAction action = new CommonDataEditAction();
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
action.DataTableName = "省份";
action.ActionType = "添加";
action.ActionTime = DateTime.Now;
action.NewValue = "省份名称：" + provRow.ProvinceName;
SysLog.LogCommonDataEditAction(action);
}
public void InsertExpenseCategory(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string ExpenseCategoryName, bool IsActive)
{
// 验证是否存在 ExpenseCategoryName 同名数据。
int iCount = (int)this.ExpenseCategoryAdapter.SearchCateByIns(ExpenseCategoryName);
if (iCount > 0) {
throw new ApplicationException("费用大类名称重名");
}
// 进行数据新增处理
ERS.ExpenseCategoryDataTable cateTab = new ERS.ExpenseCategoryDataTable();
ERS.ExpenseCategoryRow cateRow = cateTab.NewExpenseCategoryRow();
cateRow.ExpenseCategoryName = ExpenseCategoryName;
cateRow.IsActive = IsActive;
// 填加行并进行更新处理
cateTab.AddExpenseCategoryRow(cateRow);
this.ExpenseCategoryAdapter.Update(cateTab);
CommonDataEditAction action = new CommonDataEditAction();
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
action.DataTableName = "费用大类";
action.ActionType = "添加";
action.ActionTime = DateTime.Now;
action.NewValue = "费用大类：" + cateRow.ExpenseCategoryName;
SysLog.LogCommonDataEditAction(action);
}
public void InsertCustomer(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string CustomerName, string CustomerNo, int CityID, int CustomerTypeID, int ChannelTypeID, int ApplyOrganizationUnitID, int OrganizationUnitID, Boolean IsActive)
{
if (ApplyOrganizationUnitID <= 0) {
throw new ApplicationException("必须选择所属机构！");
}
if (OrganizationUnitID <= 0) {
throw new ApplicationException("必须选择所属预算机构！");
}
// 检证"客户名称"唯一性
int iCount = (int)this.CustomerAdapter.SearchNameByIns(CustomerName);
if (iCount > 0) {
throw new ApplicationException("客户名称不能重复！");
}
// 进行数据新增处理
ERS.CustomerDataTable custItemTab = new ERS.CustomerDataTable();
ERS.CustomerRow custRow = custItemTab.NewCustomerRow();
// 进行传值
custRow.CustomerName = CustomerName;
custRow.CustomerNo = CustomerNo;
custRow.CustomerTypeID = CustomerTypeID;
custRow.CityID = CityID;
custRow.ChannelTypeID = ChannelTypeID;
custRow.OrganizationUnitID = OrganizationUnitID;
custRow.ApplyOrganizationUnitID = ApplyOrganizationUnitID;
custRow.IsActive = IsActive;
// 填加行并进行更新处理
custItemTab.AddCustomerRow(custRow);
this.CustomerAdapter.Update(custItemTab);
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "添加";
action.DataTableName = "客户";
action.NewValue = "客户名称：" + custRow.CustomerName;
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
SysLog.LogCommonDataEditAction(action);
}
public void InsertCity(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int ProvId, string CityName, bool IsActive)
{
// 检证"城市"唯一性
int iCount = (int)this.CityAdapter.SearchCityNameByIns(CityName, ProvId);
if (iCount > 0) {
throw new ApplicationException("在同一省份下，城市名称不能重复！");
}
// 进行数据新增处理
ERS.CityDataTable cityTab = new ERS.CityDataTable();
ERS.CityRow cityRow = cityTab.NewCityRow();
// 进行传值
cityRow.ProvinceID = ProvId;
cityRow.CityName = CityName;
cityRow.IsActive = IsActive;
// 填加行并进行更新处理
cityTab.AddCityRow(cityRow);
this.CityAdapter.Update(cityTab);
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "添加";
action.DataTableName = "城市";
action.NewValue = "城市名称：" + cityRow.CityName;
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
SysLog.LogCommonDataEditAction(action);
}
public void UpdateSKU(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int SKUCategoryID, string SKUNo, string SKUName, string Spec,
int PackageQuantity, decimal PackagePercent, string SKUCostCenter, Boolean IsActive, int SKUID, decimal CostPrice, string Taste)
{
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "更新";
action.DataTableName = "产品";
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
// 根据 SKUID 查找要修改的数据
ERS.SKUDataTable SKUTab = this.SKUAdapter.GetDataById(SKUID);
ERS.SKURow SKURow = SKUTab[0];
action.OldValue = "产品名称：" + SKURow.SKUName;
SKURow.SKUName = SKUName;
SKURow.SKUNo = SKUNo;
SKURow.Spec = Spec;
SKURow.PackageQuantity = PackageQuantity;
SKURow.PackagePercent = PackagePercent;
SKURow.IsActive = IsActive;
SKURow.SKUCategoryID = SKUCategoryID;
SKURow.SKUCostCenter = SKUCostCenter == null ? "" : SKUCostCenter;
SKURow.CostPrice = CostPrice;
SKURow.Taste = Taste;
// 更新数据
this.SKUAdapter.Update(SKURow);
action.NewValue = "产品名称：" + SKURow.SKUName;
SysLog.LogCommonDataEditAction(action);
}
public void InsertSKU(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int SKUCategoryID, string SKUNo, string SKUName, string Spec,
int PackageQuantity, decimal PackagePercent, string SKUCostCenter, Boolean IsActive, decimal CostPrice, string Taste)
{
// 进行数据新增处理
ERS.SKUDataTable SKUTab = new ERS.SKUDataTable();
ERS.SKURow SKURow = SKUTab.NewSKURow();
// 进行传值
SKURow.SKUName = SKUName;
SKURow.SKUNo = SKUNo;
SKURow.Spec = Spec;
SKURow.PackageQuantity = PackageQuantity;
SKURow.PackagePercent = PackagePercent;
SKURow.IsActive = IsActive;
SKURow.SKUCategoryID = SKUCategoryID;
SKURow.SKUCostCenter = SKUCostCenter == null ? "" : SKUCostCenter;
SKURow.CostPrice = CostPrice;
SKURow.Taste = Taste;
// 填加行并进行更新处理
SKUTab.AddSKURow(SKURow);
this.SKUAdapter.Update(SKUTab);
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "添加";
action.DataTableName = "产品";
action.NewValue = "产品名称：" + SKURow.SKUName;
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
SysLog.LogCommonDataEditAction(action);
}
public void UpdateSubCategory(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, int ExpenseSubCategoryId, string ExpenseSubCategoryName, int CateId, int PageType, Boolean IsActive)
{
// 检证"费用小类"唯一性
int iCount = (int)this.ExpenseSubCategoryAdapter.SearchSubCateNameByUpd(ExpenseSubCategoryId, ExpenseSubCategoryName, CateId);
if (iCount > 0) {
throw new ApplicationException("在同一费用大类下，费用小类名称不能重复！");
}
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "更新";
action.DataTableName = "费用小类";
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
// 根据 CurrId 查找要修改的数据
ERS.ExpenseSubCategoryDataTable subCateTab = this.ExpenseSubCategoryAdapter.GetDataById(ExpenseSubCategoryId);
ERS.ExpenseSubCategoryRow subCateRow = subCateTab[0];
action.OldValue = "费用小类名称：" + subCateRow.ExpenseSubCategoryName;
subCateRow.ExpenseSubCategoryName = ExpenseSubCategoryName;
subCateRow.PageType = PageType;
subCateRow.IsActive = IsActive;
// 更新数据
this.ExpenseSubCategoryAdapter.Update(subCateRow);
action.NewValue = "费用小类名称：" + subCateRow.ExpenseSubCategoryName;
SysLog.LogCommonDataEditAction(action);
}
public void InsertSubCategory(AuthorizationDS.StuffUserRow stuffUser, AuthorizationDS.PositionRow position, string ExpenseSubCategoryName, int CateId, int PageType, Boolean IsActive)
{
// 检证"费用小类"唯一性
int iCount = (int)this.ExpenseSubCategoryAdapter.SearchSubCateNameByIns(ExpenseSubCategoryName, CateId);
if (iCount > 0) {
throw new ApplicationException("在同一费用大类下，费用小类不能重复！");
}
// 进行数据新增处理
ERS.ExpenseSubCategoryDataTable subCateTab = new ERS.ExpenseSubCategoryDataTable();
ERS.ExpenseSubCategoryRow subCateRow = subCateTab.NewExpenseSubCategoryRow();
// 进行传值
subCateRow.ExpenseCategoryID = CateId;
subCateRow.ExpenseSubCategoryName = ExpenseSubCategoryName;
subCateRow.PageType = PageType;
subCateRow.IsActive = IsActive;
// 填加行并进行更新处理
subCateTab.AddExpenseSubCategoryRow(subCateRow);
this.ExpenseSubCategoryAdapter.Update(subCateTab);
CommonDataEditAction action = new CommonDataEditAction();
action.ActionTime = DateTime.Now;
action.ActionType = "添加";
action.DataTableName = "费用小类";
action.NewValue = "费用小类名称：" + subCateRow.ExpenseSubCategoryName;
action.StuffId = stuffUser.StuffId;
action.StuffName = stuffUser.StuffName;
SysLog.LogCommonDataEditAction(action);
}
public static void LogCommonDataEditAction(CommonDataEditAction action)
{
SysTrace.TraceData(TraceEventType.Information, (int)LogType.CommonDateEdit, action);
}
public void LogCommonDataEditAction(CommonDataEditAction action)
{
LogDS logDS = new LogDS();
LogDS.CommonDataEditActionLogRow log = logDS.CommonDataEditActionLog.NewCommonDataEditActionLogRow();
log.ActionTime = action.ActionTime;
log.ActionType = action.ActionType;
log.DataTableName = action.DataTableName;
if (action.NewValue != null) {
log.NewValue = action.NewValue;
}
if (action.OldValue != null) {
log.OldValue = action.OldValue;
}
if (action.StuffId != null) {
log.StuffId = action.StuffId;
}
log.StuffName = action.StuffName;
logDS.CommonDataEditActionLog.AddCommonDataEditActionLogRow(log);
this.CommonDataEditActionLogTA.Update(logDS.CommonDataEditActionLog);
}
