public static void UpdateComRevenue(SysCompany company, decimal dBalance, decimal dBalanceCash, decimal dSum)
{
company.CompanyBalance = Convert.ToDecimal(company.CompanyBalance) + dBalance;
company.CompanyBalanceCash = Convert.ToDecimal(company.CompanyBalanceCash) + dBalanceCash;
company.CompanySaleSum = Convert.ToDecimal(company.CompanySaleSum) + dSum;
company.Save( );
SysMember user = DB.Select( ).From<SysMember>( )
.Where(SysMember.CompanyIdColumn).IsEqualTo(company.Id)
.ExecuteSingle<SysMember>( );
if (user != null)
{
user.MemberBalance = Convert.ToDecimal(user.MemberBalance) + dBalance;
user.MemberBalanceCash = Convert.ToDecimal(user.MemberBalanceCash) + dBalanceCash;
user.MemberSum = Convert.ToDecimal(user.MemberSum) + dSum;
user.Save( );
}
}
protected override void On_ActionEdit(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtMenuName.Text.Trim()))
{
lblMessage.InnerHtml = "请输入菜单名称.";
return;
}
int dirID = Utilities.ToInt(Request.Params[ddlDirs.UniqueID]);
if (dirID <= 0)
{
lblMessage.InnerHtml = "请选择菜单的菜品系列.";
return;
}
SysTakeawayDirectory dir = SysTakeawayDirectory.FetchByID(dirID);
if (dir == null)
{
lblMessage.InnerHtml = "请选择菜单的菜品系列.";
return;
}
_company = SysCompany.FetchByID(dir.CompanyID);
SysTakeawayMenu menu = SysTakeawayMenu.FetchByID(MenuId);
var price = Utilities.ToDecimal(txtPrice.Text);
if (menu == null)
{
menu = new SysTakeawayMenu( );
menu.Code = null;
}
else if (menu.Price.HasValue && price != menu.Price.Value)
{
CompanyItemBLL.UpdateCompanyItemSum(MenuId, price, menu.Price.Value);
}
menu.Price = price;
menu.Name = txtMenuName.Text.Trim( );
menu.DirID = dir.Id;
menu.CompanyID = dir.CompanyID;
menu.IsDeleted = false;
menu.IsOutOfStock = rbOutOfStock.SelectedValue == "1";
if (menu.IsOutOfStock.Value)
menu.OutOfStockDate = DateTime.Now;
else
menu.OutOfStockDate = null;
menu.Save( );
if (string.IsNullOrEmpty(menu.Code))
{
menu.Code = menu.Id.ToString();
menu.Save();
}
_company.MenuDate = DateTime.Now;
_company.Save( );
lblMessage.InnerHtml = "保存成功";
if (MenuId == 0)
{
On_ActionQuery(sender, e);
ddlDirs.ClearSelection( );
txtCompanyTel.Value = string.Empty;
txtPrice.Text = string.Empty;
txtMenuName.Text = string.Empty;
rbOutOfStock.SelectedValue = "0";
}
else
On_ActionQuery(sender, e);
}
public void Insert(string CompanyCode,string CompanyName,string CompanyPwd,string CompanyEmail,string CompanyProvince,int? CompanyCity,string CompanyArea,string CompanyLocation,string AreaDepth,string CompanyAddress,string CompanyTel,string CompanyPhone,string CompanyMsn,string CompanySkype,string CompanyPhoto,string CompanyIntro,string CompanyContent,bool? IsUseFinger,DateTime? CompanyDate,DateTime? CompanyDateView,int? CompanyStatus,string CompanyMemo,string CompanyRate,string CompanyRateSale,decimal? CompanyRateMaster,int? CompanySaleCount,decimal? CompanySaleSum,decimal? CompanyBalance,decimal? CompanyBalanceCash,int? CompanyFacebookCount,string CompanyToken,int? CompanyType,string CompanyItem,int? CreatedBy,DateTime? CreatedOn,int? ModifiedBy,DateTime? ModifiedOn,string CompanyWorkTime,string CompanyServices,string MsnPhoneNum,string OrderElapsed,int? OrderMaxAmount,bool? IsUseMsg,decimal? OnSetSum,decimal? ServiceSum,DateTime? MenuDate,DateTime? SetTopDate,bool? IsPoint,bool? IsOnSale,bool? IsSuspend)
{
SysCompany item = new SysCompany();
item.CompanyCode = CompanyCode;
item.CompanyName = CompanyName;
item.CompanyPwd = CompanyPwd;
item.CompanyEmail = CompanyEmail;
item.CompanyProvince = CompanyProvince;
item.CompanyCity = CompanyCity;
item.CompanyArea = CompanyArea;
item.CompanyLocation = CompanyLocation;
item.AreaDepth = AreaDepth;
item.CompanyAddress = CompanyAddress;
item.CompanyTel = CompanyTel;
item.CompanyPhone = CompanyPhone;
item.CompanyMsn = CompanyMsn;
item.CompanySkype = CompanySkype;
item.CompanyPhoto = CompanyPhoto;
item.CompanyIntro = CompanyIntro;
item.CompanyContent = CompanyContent;
item.IsUseFinger = IsUseFinger;
item.CompanyDate = CompanyDate;
item.CompanyDateView = CompanyDateView;
item.CompanyStatus = CompanyStatus;
item.CompanyMemo = CompanyMemo;
item.CompanyRate = CompanyRate;
item.CompanyRateSale = CompanyRateSale;
item.CompanyRateMaster = CompanyRateMaster;
item.CompanySaleCount = CompanySaleCount;
item.CompanySaleSum = CompanySaleSum;
item.CompanyBalance = CompanyBalance;
item.CompanyBalanceCash = CompanyBalanceCash;
item.CompanyFacebookCount = CompanyFacebookCount;
item.CompanyToken = CompanyToken;
item.CompanyType = CompanyType;
item.CompanyItem = CompanyItem;
item.CreatedBy = CreatedBy;
item.CreatedOn = CreatedOn;
item.ModifiedBy = ModifiedBy;
item.ModifiedOn = ModifiedOn;
item.CompanyWorkTime = CompanyWorkTime;
item.CompanyServices = CompanyServices;
item.MsnPhoneNum = MsnPhoneNum;
item.OrderElapsed = OrderElapsed;
item.OrderMaxAmount = OrderMaxAmount;
item.IsUseMsg = IsUseMsg;
item.OnSetSum = OnSetSum;
item.ServiceSum = ServiceSum;
item.MenuDate = MenuDate;
item.SetTopDate = SetTopDate;
item.IsPoint = IsPoint;
item.IsOnSale = IsOnSale;
item.IsSuspend = IsSuspend;
item.Save(UserName);
}
