/// <summary>
/// Ajouter un furnisseur dans la table 'Supplier' et dans la table 'SitesSupplier'
/// </summary>
/// <param name="sup"></param>
public static void InsertSupplier(Supplier sup, SiteSupplier ss)
{
SupplierDal.Insert(sup);
ss.sup_id = SupplierDal.LoadAll().Last <Supplier>().sup_id;
InsertSupplierSite(ss);
}
/// <summary>
/// 处理控件及内容的初始化，对于下拉列表默认选中第一个
/// </summary>
void InitUI()
{
try
{
//绑定供应商
List <SupplierEntity> suppliers = new SupplierDal().ListActiveSupplierByPriority();
listSupplier.Properties.DataSource = suppliers;
if (suppliers.Count > 0)
{
listSupplier.EditValue = suppliers[0].SupplierCode;
}
//绑定采购业务员
UserDal userDal = new UserDal();
listSales.Properties.DataSource = userDal.ListUsersByRoleAndOrgCode(GlobeSettings.LoginedUser.OrgCode, GlobeSettings.POSalesRoleName);
//绑定业务类型并默认选中第一个
List <BaseCodeEntity> instoreTypes = BaseCodeDal.GetItemList(BaseCodeConstant.PO_TYPE);
listBillType.Properties.DataSource = instoreTypes;
if (instoreTypes.Count > 0)
{
listBillType.EditValue = instoreTypes[0].ItemValue;
}
//明细表格默认绑定到LineEntity集合
bindingSource1.DataSource = new List <PODetailEntity>();
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
}
public async Task <string> GetSupplierInfoByID(string info)
{
if (string.IsNullOrWhiteSpace(info))
{
return(JsonConvert.SerializeObject(new
{
status = "fail",
message = "供应商ID不能为空",
date = DateTime.Now
}));
}
int ID = Convert.ToInt32(info);
SupplierDal dal = new SupplierDal();
var result = await dal.GetSupplierInfoByID(ID);
if (result.ResultCode != 0)
{
return(JsonConvert.SerializeObject(new
{
status = "fail",
message = result.ResultMsg,
date = DateTime.Now
}));
}
return(JsonConvert.SerializeObject(new
{
status = "success",
data = result.Data,
date = DateTime.Now
}));
}
public async Task <string> PageGetSupplierInfo(string info)
{
PageSupplierQueryInfo pageSupplierQueryInfo = new PageSupplierQueryInfo();
if (!string.IsNullOrWhiteSpace(info))
{
pageSupplierQueryInfo = JsonConvert.DeserializeObject <PageSupplierQueryInfo>(info);
}
SupplierDal dal = new SupplierDal();
var result = await dal.PageGetSupplierInfo(pageSupplierQueryInfo);
if (result.ResultCode != 0)
{
return(JsonConvert.SerializeObject(new
{
status = "fail",
message = result.ResultMsg,
date = DateTime.Now.ToShortDateString()
}));
}
return(JsonConvert.SerializeObject(new
{
status = "success",
data = result.Data,
date = DateTime.Now.ToShortDateString()
}));
}
/// <summary>
/// Trouver les furniseurs pour un site
/// </summary>
/// <param name="sit_id">UInt32</param>
/// <returns>List<Supplier></returns>
public static List <Supplier> LoadAllBySite(UInt32 sit_id)
{
List <Supplier> listSup = new List <Supplier>();
foreach (SiteSupplier ss in SiteSupplierDal.LoadAll(sit_id))
{
listSup.Add(SupplierDal.Load(ss.sit_id));
}
return(listSup);
}
public HttpResponseMessage GetSuppliers()
{
try
{
List <SupplierModel> suppliers = SupplierDal.GetSuppliers();
return(Request.CreateResponse(HttpStatusCode.OK, suppliers));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
public HttpResponseMessage GetSupplierById(int id)
{
try
{
SupplierModel supplier = SupplierDal.GetSupplierById(id);
return(Request.CreateResponse(HttpStatusCode.OK, supplier));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest));
}
}
/// <summary>
/// Trouver les furniseurs pour un site
/// </summary>
/// <param name="site">Site</param>
/// <returns>List<Supplier></returns>
public static List <Supplier> LoadAllSupplier(Site site)
{
List <Supplier> listSup = new List <Supplier>();
List <SiteSupplier> listSupSit = SiteSupplierDal.LoadAll(site.sit_id);
foreach (SiteSupplier ss in listSupSit)
{
Console.Write(ss.sup_id);
listSup.Add(SupplierDal.Load(ss.sup_id));
}
return(listSup);
}
private void OnFormLoad(object sender, EventArgs e)
{
ImageCollection ic = AppResource.LoadToolImages();
barManager1.Images = ic;
toolRefresh.ImageIndex = (int)AppResource.EIcons.refresh;
toolSearch.ImageIndex = (int)AppResource.EIcons.search;
toolAdd.ImageIndex = (int)AppResource.EIcons.add;
toolEdit.ImageIndex = (int)AppResource.EIcons.edit;
toolDel.ImageIndex = (int)AppResource.EIcons.delete;
supplierDal = new SupplierDal();
LoadDataAndBindGrid();
}
public IHttpActionResult Register(SupplierModel i_SupplierModel)
{
if (i_SupplierModel == null)
{
return(BadRequest("Supplier Not Valid"));
}
try
{
SupplierDal.Register(i_SupplierModel);
return(Ok("Supplier Saved Successfully"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
/// <summary>
/// Add a new supplier and return if successful
/// </summary>
/// <param name="supplier"></param>
public void AddNewSupplier(Supplier supplier)
{
using (var scope = new TransactionScope())
{
using (var connection = Connector.GetConnection())
{
var supplierDal = new SupplierDal(connection);
supplierDal.Insert(supplier.Name, supplier.Contact);
supplier.Id = supplierDal.GetLastInsertId();
// Exception handling
if (supplier.Id == null)
{
throw new ArgumentNullException(nameof(supplier.Id), "Supplier Id null after insert");
}
}
scope.Complete();
}
}
private void OnFormLoad(object sender, EventArgs e)
{
supplierDal = new SupplierDal();
provinceDal = new ProvinceDal();
BindingCombox();
if (supplierEntity != null)
{
this.Text = "供应商-修改";
txtCode.Enabled = false;
layoutControlItem3.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
ShowEditInfo(supplierEntity);
isNew = false;
//非自有数据不允许编辑
if (supplierEntity.IsOwn == "N")
{
btnSave.Enabled = false;
}
}
}
public async Task <string> AddSupplierInfo(string info)
{
SupplierInfo supplierInfo = JsonConvert.DeserializeObject <SupplierInfo>(info);
SupplierDal dal = new SupplierDal();
var result = await dal.AddSupplierInfo(supplierInfo);
if (result.ResultCode != 0)
{
return(JsonConvert.SerializeObject(new
{
status = "fail",
message = result.ResultMsg,
date = DateTime.Now.ToShortDateString()
}));
}
return(JsonConvert.SerializeObject(new
{
status = "success",
data = result.Data,
date = DateTime.Now.ToShortDateString()
}));
}
/// <summary>
/// MaJ d'un furnisseur
/// </summary>
/// <param name="sup">Supplier</param>
public static void UpdateSupplier(Supplier sup)
{
SupplierDal.Update(sup);
}
void BindingSuppliers()
{
List <SupplierEntity> suppliers = new SupplierDal().ListActiveSupplierByPriority();
listSupplers.Properties.DataSource = suppliers;
}
/// <summary>
/// Trouver les furnssieurs
/// </summary>
/// <returns>List<Supplier></returns>
public static List <Supplier> LoadAllSupplier()
{
return(SupplierDal.LoadAll());
}
public SupplierManager()
{
supplierDal = SupplierDal.GetInstance();
}
