private void LoadSupplier(string name)
{
ISupplierBll bll = new SupplierBll(_log);
_listOfSupplier = bll.GetByName(name);
FillDataHelper.FillSupplier(chkListBox, _listOfSupplier);
}
// GET: InStock
public ActionResult Index()
{
long hotelId = UserContext.CurrentUser.HotelId;
ViewData["supplier"] = SupplierBll.GetAllList(hotelId);
ViewData["warehourse"] = WarehouseBll.GetAllList(hotelId);
return(View());
}
protected void GridViewProduct_DeleteProd(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
SupplierBll.DeleteProduct(Convert.ToUInt32(lb.CommandArgument));
BindDataProduct();
}
private void LoadSupplier()
{
ISupplierBll bll = new SupplierBll(_log);
_listOfSupplier = bll.GetAll();
FillDataHelper.FillSupplier(chkListBox, _listOfSupplier);
}
protected void GridViewSupplier_DeleteSup(object sender, EventArgs e)
{
LinkButton lb = (LinkButton)sender;
Site site = (Site)Session["site"];
SupplierBll.DeleteSupplier(Convert.ToUInt32(lb.CommandArgument), site.sit_id);
Session["supplier"] = null;
BindDataSupplier();
BindDataProduct();
}
protected void GridViewProduct_AddProd(object sender, EventArgs e)
{
Product prd = new Product();
String price = ((TextBox)GridViewProduct.FooterRow.FindControl("txt_prd_price")).Text;
if (String.IsNullOrEmpty(price) || String.IsNullOrWhiteSpace(price))
{
return;
}
prd.prd_name = ((TextBox)GridViewProduct.FooterRow.FindControl("txt_prd_name")).Text;
try
{
prd.prd_price = Decimal.Parse(price);
}
catch (Exception ex)
{
prd.prd_price = (Decimal)0.00;
}
prd.prd_sup_no = ((TextBox)GridViewProduct.FooterRow.FindControl("txt_prd_sup_no")).Text;
prd.prd_memo = ((TextBox)GridViewProduct.FooterRow.FindControl("txt_prd_memo")).Text;
if (String.IsNullOrEmpty(prd.prd_name) || String.IsNullOrWhiteSpace(prd.prd_name))
{
return;
}
foreach (Product prod in SupplierBll.LoadAllProduct())
{
if (prod.prd_sup_no.Equals(prd.prd_sup_no))
{
return;
}
}
Supplier sup = (Supplier)Session["supplier"];
prd.sup_id = sup.sup_id;
try
{
SupplierBll.InsertProduct(prd);
GridViewProduct.PageIndex = GridViewProduct.PageCount;
BindDataProduct();
}
catch (ManagedException ex)
{
Utils.DisplayMessage(UpdatePanelSupplier, String.Format("alert(\"{0}\");", ex.Message));
}
}
public void Page_Load(object sender, EventArgs args)
{
site = SiteBll.GetSessionSite();
supplier = SupplierBll.GetDetailById(Request["supplier_id"].TryToLong());
var dp_case = MaterialsBll.GetMaterialsBySupplierId(supplier.supplier_id);
materials = dp_case.Table.Populate <Material>();
tdks = SeoBll.GetTDKbyPage("sjxq.aspx", Request["supplier_id"]).Table.Populate <SeoBll.Seo>();
contractorsList4global = ContractorBll.GetAllContractors(0, 500).Table.Populate <Contractor> ();
}
/// <summary>Creates a new instance of <see cref="SupplierController"></summary>
/// <param name="supplierBll">Contains business rules related to <see cref="Supplier"/> objects.</param>
/// <param name="supplierGroupBll">Contains business rules related to <see cref="SupplierGroup"/> objects.</param>
public SupplierController(SupplierBll supplierBll, SupplierGroupBll supplierGroupBll)
{
if (supplierBll == null)
{
throw new ArgumentNullException("supplierBll");
}
if (supplierGroupBll == null)
{
throw new ArgumentNullException("supplierGroupBll");
}
this.supplierBll = supplierBll;
this.supplierGroupBll = supplierGroupBll;
}
private void ShowEntrySupplier()
{
var isGrant = RolePrivilegeHelper.IsHaveHakAkses("mnuSupplier", _pengguna);
if (!isGrant)
{
MsgHelper.MsgWarning("Maaf Anda tidak mempunyai otoritas untuk mengakses menu ini");
return;
}
ISupplierBll supplierBll = new SupplierBll(_log);
var frmEntrySupplier = new FrmEntrySupplier("Tambah Data Supplier", supplierBll);
frmEntrySupplier.Listener = this;
frmEntrySupplier.ShowDialog();
}
private void LoadSupplier()
{
ISupplierBll bll = new SupplierBll(_log);
_listOfSupplier = bll.GetAll();
FillDataHelper.FillSupplier(cmbSupplier, _listOfSupplier);
if (_listOfSupplier.Count > 0)
{
cmbSupplier.SelectedIndex = 0;
}
else
{
rdoStokBerdasarkanSupplier.Enabled = false;
}
}
protected void GridViewSupplier_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Supplier sup = new Supplier();
sup.sup_id = Convert.ToUInt32(((Label)GridViewSupplier.Rows[e.RowIndex].FindControl("lbl_sup_id")).Text);
sup.sup_name = ((TextBox)GridViewSupplier.Rows[e.RowIndex].FindControl("txt_sup_name")).Text;
sup.sup_tel = ((TextBox)GridViewSupplier.Rows[e.RowIndex].FindControl("txt_sup_tel")).Text;
sup.sup_adr_no = ((TextBox)GridViewSupplier.Rows[e.RowIndex].FindControl("txt_sup_adr_no")).Text;
sup.sup_adr_street = ((TextBox)GridViewSupplier.Rows[e.RowIndex].FindControl("txt_sup_adr_street")).Text;
sup.sup_adr_city = ((TextBox)GridViewSupplier.Rows[e.RowIndex].FindControl("txt_sup_adr_city")).Text;
sup.sup_adr_prov = ((TextBox)GridViewSupplier.Rows[e.RowIndex].FindControl("txt_sup_adr_prov")).Text;
sup.sup_adr_pcode = ((TextBox)GridViewSupplier.Rows[e.RowIndex].FindControl("txt_sup_adr_pcode")).Text;
SupplierBll.UpdateSupplier(sup);
GridViewSupplier.EditIndex = -1;
BindDataSupplier();
}
public ActionResult Delete(long id)
{
var apiResult = new APIResult();
try
{
SupplierBll.Delete(id);
}
catch (Exception ex)
{
apiResult.Ret = -1;
apiResult.Msg = ex.Message;
if (!(ex is OperationExceptionFacade))
{
LogFactory.GetLogger().Log(LogLevel.Error, ex);
}
}
return(Json(apiResult));
}
public JsonResult Edit(Hotel.Model.Inventory.Supplier model)
{
var apiResult = new APIResult();
try
{
SupplierBll.AddOrUpdate(model, UserContext.CurrentUser.Name, UserContext.CurrentUser.HotelId);
}
catch (Exception ex)
{
apiResult.Ret = -1;
apiResult.Msg = ex.Message;
if (!(ex is OperationExceptionFacade))
{
LogFactory.GetLogger().Log(LogLevel.Error, ex);
}
}
return(Json(apiResult));
}
public string GetById(long id)
{
StockOrder model = StockOrderBll.GetById(id);
if (model != null)
{
var supply = SupplierBll.GetById(model.SupplierId);
var warehourse = WarehouseBll.GetById(model.FromWarehourseId);
if (supply != null)
{
model.SupplierName = supply.Name;
}
if (warehourse != null)
{
model.FromWarehourseName = warehourse.Name;
}
}
return(JsonConvert.SerializeObject(model));
}
public ActionResult Preview(long id = 0)
{
long hotelId = UserContext.CurrentUser.HotelId;
ViewData["supplier"] = SupplierBll.GetAllList(hotelId);
ViewData["warehourse"] = WarehouseBll.GetAllList(hotelId);
if (id == 0)
{
return(View(new OutStockArgs()
{
Item1 = new StockOrder(), Item2 = new List <StockOrderDetails>()
}));
}
StockOrder model = StockOrderBll.GetById(id);
Warehouse house = WarehouseBll.GetById(model.FromWarehourseId);
string WarehouseName = house?.Name;
//给详情附上仓库名字
List <StockOrderDetails> list = model.StockOrderDetailsList;
if (list != null && list.Count > 0)
{
for (int i = 0; i < list.Count; i++)
{
list[i].WarehouseName = WarehouseName;
}
}
var info = new OutStockArgs
{
Item1 = model,
Item2 = list,
};
return(View(info));
}
public ActionResult Preview(long id = 0)
{
long hotelId = UserContext.CurrentUser.HotelId;
ViewData["supplier"] = SupplierBll.GetAllList(hotelId);
ViewData["warehourse"] = WarehouseBll.GetAllList(hotelId);
if (id == 0)
{
return(View(new RefundArgs()
{
Item1 = new StockOrder(), Item2 = new List <StockOrderDetails>()
}));
}
StockOrder model = StockOrderBll.GetById(id);
var info = new RefundArgs
{
Item1 = model,
Item2 = model.StockOrderDetailsList,
};
return(View(info));
}
//___________________________________PRODUCT_________________________________________________________________________________//
private void BindDataProduct()
{
Supplier sup = (Supplier)Session["supplier"];
if (sup != null)
{
List <Product> list = SupplierBll.LoadAllProduct(sup);
if (list.Count < 1)
{
list.Add(new Product());
}
GridViewProduct.DataSource = list;
GridViewProduct.DataBind();
GridViewProduct.SelectedIndex = -1;
}
else
{
GridViewProduct.DataSource = null;
GridViewProduct.DataBind();
lblProduct.Text = "Choisir un fourniseur";
}
}
public ActionResult Edit(long id = 0)
{
List <SupplierType> supTypeList = SupplierTypeBll.GetList(UserContext.CurrentUser.HotelId);
List <SelectListItem> items = new List <SelectListItem>();
foreach (var item in supTypeList)
{
items.Add(new SelectListItem {
Text = item.Name, Value = item.Id.ToString()
});
}
ViewData["hotelTypeList"] = items;
if (id == 0)
{
return(View(new Hotel.Model.Inventory.Supplier()
{
HotelId = UserContext.CurrentUser.HotelId
}));
}
var info = SupplierBll.GetById(id);
return(View(info));
}
protected void GridViewProduct_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Product prd = new Product();
Supplier sup = (Supplier)Session["supplier"];
prd.sup_id = sup.sup_id;
prd.prd_id = Convert.ToUInt32(((Label)GridViewProduct.Rows[e.RowIndex].FindControl("lbl_prd_id")).Text);
prd.prd_name = ((TextBox)GridViewProduct.Rows[e.RowIndex].FindControl("txt_prd_name")).Text;
String price = ((TextBox)GridViewProduct.Rows[e.RowIndex].FindControl("txt_prd_price")).Text;
if (String.IsNullOrEmpty(price) || String.IsNullOrWhiteSpace(price))
{
return;
}
try
{
prd.prd_price = Decimal.Parse(price);
}
catch (Exception ex)
{
prd.prd_price = (Decimal)0.00;
}
prd.prd_sup_no = ((TextBox)GridViewProduct.Rows[e.RowIndex].FindControl("txt_prd_sup_no")).Text;
prd.prd_memo = ((TextBox)GridViewProduct.Rows[e.RowIndex].FindControl("txt_prd_memo")).Text;
SupplierBll.UpdateProduct(prd);
GridViewProduct.EditIndex = -1;
BindDataProduct();
}
//___________________________________SUPPLIER_________________________________________________________________________________//
private void BindDataSupplier()
{
Site site = (Site)Session["site"];
if (site != null)
{
List <Supplier> list = SupplierBll.LoadAllSupplier(site);
if (list.Count() < 1)
{
list.Add(new Supplier());
}
GridViewSupplier.DataSource = list;
GridViewSupplier.DataBind();
GridViewSupplier.SelectedIndex = -1;
}
else
{
GridViewSupplier.DataSource = null;
GridViewSupplier.DataBind();
lbl.Text = "Choisissez un SITE";
}
}
public void SetUp()
{
supplierDal = new Mock <ISupplierDal>();
supplierBll = new SupplierBll(supplierDal.Object);
}
protected void GridViewSupplier_AddSup(object sender, EventArgs e)
{
Supplier sup = new Supplier();
sup.sup_name = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_name")).Text;
sup.sup_tel = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_tel")).Text;
sup.sup_adr_no = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_no")).Text;
sup.sup_adr_street = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_street")).Text;
sup.sup_adr_city = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_city")).Text;
sup.sup_adr_prov = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_prov")).Text;
sup.sup_adr_pcode = ((TextBox)GridViewSupplier.FooterRow.FindControl("txt_sup_adr_pcode")).Text;
Boolean suppExist = false;
if (String.IsNullOrEmpty(sup.sup_name) || String.IsNullOrWhiteSpace(sup.sup_name))
{
return;
}
foreach (Supplier supp in SupplierBll.LoadAllSupplier())
{
if (supp.sup_name.Equals(sup.sup_name))
{
suppExist = true;
sup.sup_id = supp.sup_id;
}
}
Site site = (Site)Session["site"];
SiteSupplier ss = new SiteSupplier();
ss.sit_id = site.sit_id;
ss.sup_id = sup.sup_id;
if (suppExist)
{
foreach (SiteSupplier ssup in SupplierBll.LoadAllSiteSupplier())
{
if (ssup.sit_id.Equals(ss.sit_id) && ssup.sup_id.Equals(ss.sup_id))
{
return;
}
}
}
try
{
if (suppExist)
{
SupplierBll.InsertSupplierSite(ss);
}
else
{
SupplierBll.InsertSupplier(sup, ss);
}
GridViewSupplier.PageIndex = GridViewSupplier.PageCount;
BindDataSupplier();
}
catch (ManagedException ex)
{
Utils.DisplayMessage(UpdatePanelSupplier, String.Format("alert(\"{0}\");", ex.Message));
}
}
public string GetPager(int page, int rows, string supplierName, string supplierStatus, long supplierType = 0)
{
var pager = SupplierBll.GetPager(page, rows, UserContext.CurrentUser.HotelId, supplierName, supplierStatus, supplierType);
return(JsonConvert.SerializeObject(pager));
}
private void toolStripButton4_Click(object sender, EventArgs e)
{
ClientBll clientBll;
EmployeeBll employeeBll;
SupplierBll supplierBll;
try
{
if (MessageBox.Show("هل أنت متأكد من حذف الحساب؟") == 1)
{
int num1 = Convert.ToInt32(this.dgvAccounts.SelectedRows[0].Cells[0].Value);
int parent = this.accounts.getParent(num1);
int num2 = parent;
if (num2 != 0)
{
switch (num2)
{
case 0:
{
this.accounts.DeleteBankAccount(num1);
break;
}
case 1:
{
clientBll = new ClientBll();
clientBll.deleteClient(num1);
break;
}
case 2:
{
employeeBll = new EmployeeBll();
employeeBll.deleteEmployee(num1);
break;
}
case 32:
{
supplierBll = new SupplierBll();
supplierBll.deleteSupplier(num1);
}
}
}
else
{
this.accounts.DeleteAccount(num1);
}
MessageBox.Show("تم الحذف");
AccountsViewDataTable accountsView = this.accounts.GetAccountsView();
accountsView.BalanceColumn.ColumnName = "الرصيد";
accountsView.Category_NameColumn.ColumnName = "نوع الحساب";
accountsView.GL_IDColumn.ColumnName = "رقم الحساب";
accountsView.GL_Name_VCColumn.ColumnName = "اسم الحساب";
accountsView.ParentColumn.ColumnName = "تابع لحساب";
accountsView.Status_BTColumn.ColumnName = "مفعل";
this.dgvAccounts.DataSource = accountsView;
this.dgvAccounts.Columns["BS_Category_VC"].Visible = false;
}
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
}
protected void Button3_Click(object sender, EventArgs e)
{
int successfulcount = 0, errorcount = 0;
try
{
if (this.FileUpload1.HasFile)
{
if (!ue.SaveUpFile("~/Admin/temp/", this.FileUpload1))//上传文件
{
throw new Exception("上传文件失败!");
}
DataTable inputdt = ue.InputExcel("Sheet1");
if (inputdt == null)
{
throw new Exception("Excel文件读取失败!找不到表Sheet1");
}
int j;
string erroritems = "";
SupplierBll supp = new SupplierBll();
tab_suppliers supplier;
for (int i = 0; i < inputdt.Rows.Count; i++)
{
j = 0;
supplier = new tab_suppliers();
supplier.supplier = inputdt.Rows[i][j++].ToString().Trim();
supplier.branch = inputdt.Rows[i][j++].ToString().Trim();
supplier.hospid = inputdt.Rows[i][j++].ToString().Trim();
supplier.province = inputdt.Rows[i][j++].ToString().Trim();
supplier.city = inputdt.Rows[i][j++].ToString().Trim();
supplier.zone = inputdt.Rows[i][j++].ToString().Trim();
supplier.address = inputdt.Rows[i][j++].ToString().Trim();
supplier.phone = inputdt.Rows[i][j++].ToString().Trim();
supplier.note = inputdt.Rows[i][j++].ToString().Trim();
supplier.lat = inputdt.Rows[i][j++].ToString().Trim();
supplier.lng = inputdt.Rows[i][j++].ToString().Trim();
supplier.type = inputdt.Rows[i][j++].ToString().Trim();
try
{
if (supp.Add(supplier) < 1)
{
errorcount++;
}
else
{
successfulcount++;
}
}
catch (Exception ex)
{
ex.Message.ToString();
errorcount++;
erroritems += supplier.supplier + " " + supplier.branch + "\n";
}
}
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "message", " <script>alert('操作已完成！其中成功导入数据" + successfulcount + "条，失败" + errorcount + "条," + erroritems + "'); </script>");
GridView1.DataBind();
}
else
{
throw new Exception("请选择Excel文件!");
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "message", " <script>alert('" + ex.Message + "'); </script>");
}
}
public JsonResult CancelRefund(string refundCode)
{
try
{
SupplierBll supplierBll = new SupplierBll();
var refundModel = refundBll.GetRefundInfo(refundCode, LoginUser.UserID);
if (refundModel == null)
{
return(Json(new { Type = 0, Content = "该退款单不存在" }));
}
// var product = refundProducts.First();
//#region 结算单实体
//SettleOrderInfoEntity settleOrder = new SettleOrderInfoEntity();
//settleOrder.CreateBy = LoginUser.UserName;
//settleOrder.CreateTime = DateTime.Now;
//settleOrder.OrderCode = refundModel.OrderCode;
//settleOrder.RefundCode = refundModel.RefundCode;
//settleOrder.SettlementStatus = 1;
//settleOrder.SettlementType = refundModel.RefundType==1?2:3;
//settleOrder.SupplierId = refundModel.SupplierId;
//settleOrder.ExchangeRate = refundModel.ExchangeRate;
// settleOrder.RmbProductTotalAmount = product.RMBUnitPrice*product.Quantity;//商品总金额
//settleOrder.ProductTotalAmount = product.UnitPrice*product.Quantity;
//settleOrder.RmbProductRefundAmount =refundModel.RMBRefundTotalAmount;//商品退款总金额
//settleOrder.ProductRefundAmount = refundModel.RefundTotalAmount;
////商品结算金额=(商品总金额-商品退款总金额)*(1-服务费率)
//decimal productSettleAmount = (settleOrder.ProductTotalAmount-settleOrder.ProductRefundAmount)*(1-refundModel.Commission);
////结算金额=商品结算金额-商品税金额
//settleOrder.SettlementAmount = productSettleAmount-(refundModel.DutyAmount) ;
//settleOrder.RmbSettlementAmount = settleOrder.SettlementAmount*refundModel.ExchangeRate;
//settleOrder.OtherAmount = 0;
//settleOrder.RmbOtherAmount = 0;
//settleOrder.RmbSupplierBearDutyAmount = product.IsBearDuty==0?0:product.RMBUnitPrice*product.TaxRate;//商家承担商品税总额
//settleOrder.SupplierBearDutyAmount = product.IsBearDuty==0?0:product.UnitPrice*product.TaxRate;
//settleOrder.RmbBearDutyAmount = product.IsBearDuty==1?0:product.RMBUnitPrice*product.TaxRate;//买方承担商品税总额
//settleOrder.BearDutyAmount = product.IsBearDuty==1?0:product.UnitPrice*product.TaxRate;
//#endregion
//#region 结算商品实体
//SettleProductEntity settleProduct = new SettleProductEntity(){
// Spu = product.Spu,
// Sku = product.Sku,
// Quantity = product.Quantity,
// UnitPrice = product.UnitPrice,
// RmbUnitPrice = product.RMBUnitPrice,
// TaxRate = product.TaxRate,
// RmbAmount = product.RMBUnitPrice*product.Quantity,
// Amount = product.UnitPrice*product.Quantity,
// RmbTaxAmount = product.RMBUnitPrice*product.Quantity*product.TaxRate,
// TaxAmount = product.UnitPrice*product.Quantity*product.TaxRate,
// RmbSettlementAmount = settleOrder.RmbSettlementAmount,
// SettlementAmount = settleOrder.SettlementAmount,
// IsBearDuty = product.IsBearDuty,
// Commision = refundModel.Commission
//};
//#endregion
if (settleBll.CancelRefund(refundCode, refundModel.OrderCode, DateTime.Now, LoginUser.UserName))
{
return(Json(new { Type = 1, Content = "申诉取消成功" }));
}
else
{
return(Json(new { Type = 0, Content = "申诉取消失败" }));
}
}
catch (Exception ex)
{
LogHelper.Error(ex);
return(Json(new { Type = 0, Content = "系统错误，请稍后再试" }));
}
}
