private void LoadInventorys()
{
DataTable dt1 = InventoryLogic.GetInstance().GetInventoryView_Product(string.Empty);
DataTable dt2 = InventoryLogic.GetInstance().GetInventoryView_Property(string.Empty);
dataGridView1.DataSource = dt1;
dataGridView2.DataSource = dt2;
}
public static InventoryLogic GetInstance()
{
if (instance == null)
{
instance = new InventoryLogic();
}
return(instance);
}
public bool UpdateIncome(Income element)
{
string sql = "update TF_Income set PID=" + element.PID + ", IsProduct=" + (element.IsProduct ? "1" : "0") + ", IsIncome=" + (element.IsIncome ? "1" : "0") + ", 数量=" + element.数量 + ", 实价=" + element.实价 + ", 备注='" + element.备注 + "', 经手人='" + element.经手人 + "', 时间=getdate() where ID=" + element.ID;
int r = sqlHelper.ExecuteSql(sql);
if (r > 0)
{
InventoryLogic.GetInstance().SaveInventory(element.PID, element.IsProduct, element.IsIncome, element.数量);
return(true);
}
return(false);
}
public int AddIncome(Income element)
{
string sql = "insert into TF_Income (PID, IsProduct, IsIncome, 数量, 实价, 备注, 经手人) values (" + element.PID + ", " + (element.IsProduct ? "1" : "0") + ", " + (element.IsIncome ? "1" : "0") + "," + element.数量 + ", " + element.实价 + ", '" + element.备注 + "', '" + element.经手人 + "'); select SCOPE_IDENTITY()";
object obj = sqlHelper.ExecuteSqlReturn(sql);
int R;
if (obj != null && obj != DBNull.Value && int.TryParse(obj.ToString(), out R))
{
InventoryLogic.GetInstance().SaveInventory(element.PID, element.IsProduct, element.IsIncome, element.数量);
return(R);
}
else
{
return(0);
}
}
private DataTable Search(bool isProduct, string name, DateTime start, DateTime end)
{
DataTable dt = null;
string where = " like '%" + name + "%' and 更新时间 between '" + start.ToString("yyyy-MM-dd HH:mm:ss.fff") + "' and '" + end.ToString("yyyy-MM-dd HH:mm:ss.fff") + "' order by 更新时间 desc";;
if (isProduct)
{
where = "品名" + where;
InventoryLogic.GetInstance().GetInventoryView_Product(where);
}
else
{
where = "名称" + where;
dt = InventoryLogic.GetInstance().GetInventoryView_Property(where);
}
return(dt);
}
//public bool DeleteIncome(Income element)
//{
// string sql = "delete from TF_Income where ID=" + element.ID;
// int r = sqlHelper.ExecuteSql(sql);
// return r > 0;
//}
/// <summary>
/// 批量更新
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public bool UpgradeList(List <Income> list)
{
int errCount = 0;
foreach (Income element in list)
{
string sqlStr = "if exists (select 1 from TF_Income where ID=" + element.ID + ") update TF_Income set PID=" + element.PID + ", IsProduct=" + (element.IsProduct ? "1" : "0") + ", IsIncome=" + (element.IsIncome ? "1" : "0") + ", 数量=" + element.数量 + ", 实价=" + element.实价 + ", 备注='" + element.备注 + "', 经手人='" + element.经手人 + "', 时间=getdate() where ID=" + element.ID + " else insert into TF_Income (PID, IsProduct, IsIncome, 数量, 实价, 备注, 经手人) values (" + element.PID + ", " + (element.IsProduct ? "1" : "0") + ", " + (element.IsIncome ? "1" : "0") + "," + element.数量 + ", " + element.实价 + ", '" + element.备注 + "', '" + element.经手人 + "')";
try
{
sqlHelper.ExecuteSql(sqlStr);
InventoryLogic.GetInstance().SaveInventory(element.PID, element.IsProduct, element.IsIncome, element.数量);
}
catch (Exception)
{
errCount++;
}
}
return(errCount == 0);
}
private DataTable Search(bool isProduct, string name, DateTime start, DateTime end, int action, ProductType pt = null)
{
DataTable dt = null;
string time = " and 更新时间 between '" + start.ToString("yyyy-MM-dd HH:mm") + "' and '" + end.ToString("yyyy-MM-dd HH:mm") + "'";
string act = "";
if (action > 0)
{
act = " and 动作='" + (action == 1 ? "入库" : "出库") + "'";
}
if (isProduct)
{
string nm = "";
if (!string.IsNullOrEmpty(name) && name.Trim() != "")
{
nm = " and 品名 like '%" + name + "%'";
}
string type = "";
if (pt != null)
{
type = " and 种类='" + pt.类型 + "'";
}
string where = "(1=1)" + nm + time + act + type;
dt = InventoryLogic.GetInstance().GetInventoryView_Product(where);
}
else
{
string nm = "";
if (!string.IsNullOrEmpty(name) && name.Trim() != "")
{
nm = " and 名称 like '%" + name + "%'";
}
string where = "(1=1)" + nm + time + act;
dt = InventoryLogic.GetInstance().GetInventoryView_Property(where);
}
return(dt);
}
