public static void SaveList(List <HCMIS.Desktop.DirectoryServices.Supplier> list)
{
BLL.Supplier bv = new BLL.Supplier();
foreach (HCMIS.Desktop.DirectoryServices.Supplier v in list)
{
// try to load by primary key
bv.LoadByPrimaryKey(v.ID.Value);
// if the entry doesn't exist, create it
if (bv.RowCount == 0)
{
bv.AddNew();
}
// populate the contents of v on the to the database list
if (v.ID.HasValue)
{
bv.ID = v.ID.Value;
}
if (v.CompanyName != "" && v.CompanyName != null)
{
bv.CompanyName = v.CompanyName;
}
if (v.Address != "" && v.Address != null)
{
bv.Address = v.Address;
}
if (v.Telephone != "" && v.Telephone != null)
{
bv.Telephone = v.Telephone;
}
if (v.ContactPerson != "" && v.ContactPerson != null)
{
bv.ContactPerson = v.ContactPerson;
}
if (v.Mobile != "" && v.Mobile != null)
{
bv.Mobile = v.Mobile;
}
if (v.CompanyInfo != "" && v.CompanyInfo != null)
{
bv.CompanyInfo = v.CompanyInfo;
}
if (v.IsActive.HasValue)
{
bv.IsActive = v.IsActive.Value;
}
if (v.Email != "" && v.Email != null)
{
bv.Email = v.Email;
}
//if( v.IsDeleted.HasValue )
// bv.IsDeleted = v.IsDeleted.Value;
//if( v.UpdateTime.HasValue )
// bv.UpdateTime = v.UpdateTime.Value;
bv.Save();
}
}
private void CostAnalysis_Load(object sender, EventArgs e)
{
gridJournal.DataSource = dvJournal;
var store = new BLL.Activity();
store.LoadByPrimaryKey(storeID);
textEdit1.EditValue = store.Name;
var supplier = new BLL.Supplier();
supplier.LoadByPrimaryKey(supplierID);
textEdit2.EditValue = supplier.CompanyName;
}
public bool PORefNo_Filter(object obj)
{
try
{
BLL.PurchaseReturn PO = obj as BLL.PurchaseReturn;
BLL.Supplier S = cmbSupplier.SelectedItem as BLL.Supplier;
return(PO.SupplierId == S.Id);
}
catch (Exception ex) { }
return(false);
}
private void CostAnalysis_Load(object sender, EventArgs e)
{
gridJournal.DataSource = dvJournal;
var store = new BLL.Activity();
store.LoadByPrimaryKey(storeID);
textEdit1.EditValue = store.Name;
var supplier = new BLL.Supplier();
supplier.LoadByPrimaryKey(supplierID);
textEdit2.EditValue = supplier.CompanyName;
}
public static List <Supplier> ToList(BLL.Supplier v)
{
List <Supplier> list = new List <Supplier>();
while (!v.EOF)
{
Supplier t = new Supplier();
if (!v.IsColumnNull("ID"))
{
t.ID = v.ID;
}
if (!v.IsColumnNull("CompanyName"))
{
t.CompanyName = v.CompanyName;
}
if (!v.IsColumnNull("Address"))
{
t.Address = v.Address;
}
if (!v.IsColumnNull("Telephone"))
{
t.Telephone = v.Telephone;
}
if (!v.IsColumnNull("ContactPerson"))
{
t.ContactPerson = v.ContactPerson;
}
if (!v.IsColumnNull("Mobile"))
{
t.Mobile = v.Mobile;
}
if (!v.IsColumnNull("CompanyInfo"))
{
t.CompanyInfo = v.CompanyInfo;
}
if (!v.IsColumnNull("IsActive"))
{
t.IsActive = v.IsActive;
}
if (!v.IsColumnNull("Email"))
{
t.Email = v.Email;
}
//if(!v.IsColumnNull("IsDeleted"))
// t.IsDeleted = v.IsDeleted;
//if(!v.IsColumnNull("UpdateTime"))
// t.UpdateTime = v.UpdateTime;
list.Add(t);
v.MoveNext();
}
return(list);
}
public static List <int> GetDeletedIDsAfter(long LastVersion)
{
BLL.Supplier v = new BLL.Supplier();
//v.LoadDeletedIDs(LastVersion);
List <int> list = new List <int>();
while (!v.EOF)
{
list.Add((int)v.GetColumn("ID"));
v.MoveNext();
}
return(list);
}
public JsonResult addupd(Model.SupplierInfo supplier)
{
string strResult = "FAIL";
if (supplier.SupplierName != null)
{
MoyeBuy.Com.BLL.Supplier bsupplier = new BLL.Supplier();
if (bsupplier.AddUpdateProductSupplier(supplier))
{
strResult = "SUCCESS";
}
}
return(Json(strResult));
}
public JsonResult Del(string SupplierID)
{
string strResult = "FAIL";
if (SupplierID != "")
{
MoyeBuy.Com.BLL.Supplier bsupplier = new BLL.Supplier();
if (bsupplier.DelProductSupplierByID(SupplierID))
{
strResult = "SUCCESS";
}
}
return(Json(strResult));
}
public static void DeleteList(List <int> list)
{
BLL.Supplier bv = new BLL.Supplier();
foreach (int v in list)
{
// try to load by primary key
bv.LoadByPrimaryKey(v);
// if the entry doesn't exist, create it
if (bv.RowCount > 0)
{
bv.MarkAsDeleted();
bv.Save();
}
// populate the contents of v on the to the database list
}
}
public static List <Supplier> GetUpdatesAfter(long?lastVersion, DateTime?lastUpdateTime)
{
BLL.Supplier v = new BLL.Supplier();
if (lastVersion.HasValue && lastVersion.Value != 0)
{
v.LoadUpdatesAfter(Convert.ToInt32(lastVersion.Value));
}
else if (lastUpdateTime.HasValue)
{
// v.LoadUpdatesAfterByTime(lastUpdateTime.Value);
}
else
{
v.LoadAll();
}
return(ToList(v));
}
protected void Button2_Click(object sender, EventArgs e)
{
DataSet ds = new BLL.Product().GetAllList();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Model.Supplier mo_supp = new Model.Supplier();
string s_name = ds.Tables[0].Rows[i]["Name"].ToString();
if (s_name.Length > 1)
{
s_name = s_name.Substring(0, 2);
}
mo_supp.Name = s_name;
mo_supp.Address = s_name;
BLL.Supplier bl_supp = new BLL.Supplier();
bl_supp.Add(mo_supp);
}
}
public static void DeleteList(List<int> list)
{
BLL.Supplier bv = new BLL.Supplier();
foreach (int v in list)
{
// try to load by primary key
bv.LoadByPrimaryKey(v);
// if the entry doesn't exist, create it
if (bv.RowCount > 0)
{
bv.MarkAsDeleted();
bv.Save();
}
// populate the contents of v on the to the database list
}
}
public static List<int> GetDeletedIDsAfter(long LastVersion)
{
BLL.Supplier v = new BLL.Supplier();
//v.LoadDeletedIDs(LastVersion);
List<int> list = new List<int>();
while (!v.EOF)
{
list.Add((int)v.GetColumn("ID"));
v.MoveNext();
}
return list;
}
public static List<Supplier> GetUpdatesAfter(long? lastVersion,DateTime? lastUpdateTime)
{
BLL.Supplier v = new BLL.Supplier();
if(lastVersion.HasValue && lastVersion.Value != 0)
{
v.LoadUpdatesAfter(Convert.ToInt32( lastVersion.Value ) );
}else if(lastUpdateTime.HasValue)
{
// v.LoadUpdatesAfterByTime(lastUpdateTime.Value);
}else
{
v.LoadAll();
}
return ToList(v);
}
public static void SaveList(List<HCMIS.Desktop.DirectoryServices.Supplier> list)
{
BLL.Supplier bv = new BLL.Supplier();
foreach (HCMIS.Desktop.DirectoryServices.Supplier v in list)
{
// try to load by primary key
bv.LoadByPrimaryKey(v.ID.Value);
// if the entry doesn't exist, create it
if (bv.RowCount == 0)
{
bv.AddNew();
}
// populate the contents of v on the to the database list
if( v.ID.HasValue )
bv.ID = v.ID.Value;
if( v.CompanyName != "" && v.CompanyName != null )
bv.CompanyName = v.CompanyName;
if( v.Address != "" && v.Address != null )
bv.Address = v.Address;
if( v.Telephone != "" && v.Telephone != null )
bv.Telephone = v.Telephone;
if( v.ContactPerson != "" && v.ContactPerson != null )
bv.ContactPerson = v.ContactPerson;
if( v.Mobile != "" && v.Mobile != null )
bv.Mobile = v.Mobile;
if( v.CompanyInfo != "" && v.CompanyInfo != null )
bv.CompanyInfo = v.CompanyInfo;
if( v.IsActive.HasValue )
bv.IsActive = v.IsActive.Value;
if( v.Email != "" && v.Email != null )
bv.Email = v.Email;
//if( v.IsDeleted.HasValue )
// bv.IsDeleted = v.IsDeleted.Value;
//if( v.UpdateTime.HasValue )
// bv.UpdateTime = v.UpdateTime.Value;
bv.Save();
}
}
public static List <Supplier> GetAll()
{
BLL.Supplier v = new BLL.Supplier();
v.LoadAll();
return(ToList(v));
}
private string GetSupplierComboBox()
{
DataTable dt = new BLL.Supplier().GetList("").Tables[0];
return(DBUtility.JsonHelper.DataTable2Json_ValueText(dt, "ID", "FullName"));
}
public static List<Supplier> GetAll()
{
BLL.Supplier v = new BLL.Supplier();
v.LoadAll();
return ToList(v);
}
