//删除
public static void DelOptions(int iOptionsID)
{
//ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory();
ISession session = NHibernateHelper.OpenSession();
ITransaction tx = session.BeginTransaction();
ProgOptions toDelete = session.Get <ProgOptions>(iOptionsID);
//判断是否程序中已经使用的参数，如果是，不允许删除！！！
List <string> usedKey = new List <string>()
{
"RKLX", "CKLX", "RKD_LastNumber", "CKD_LastNumber"
};
if (usedKey.Contains(toDelete.OptionsKey))
{
//不能删除，返回
MessageBox.Show("此参数程序有使用，不能删除！", "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
tx.Rollback();
session.Close();
return;
}
try
{
session.Delete(toDelete);
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
void ButtonSaveClick(object sender, EventArgs e)
{
//保存
//根据是修改还是新增确定操作
if (this.Text == "系统参数-新增")
{
//确定关闭窗口，将数据保存到数据库中
ProgOptions t1 = new ProgOptions();
t1.OptionsKey = textBoxOptionsKey.Text.Trim();
t1.OptionsValue = textBoxOptionsValue.Text.Trim();
t1.OptionsRemark = textBoxOptionsRemark.Text.Trim();
BLL.ProgOptionsBLL.AddOptions(t1);
this.Close();
}
else
{
//确定关闭窗口，将数据修改后保存到数据库中
ProgOptions t1 = new ProgOptions();
t1.OptionsID = i_OptionsID;
t1.OptionsKey = textBoxOptionsKey.Text.Trim();
t1.OptionsValue = textBoxOptionsValue.Text.Trim();
t1.OptionsRemark = textBoxOptionsRemark.Text.Trim();
BLL.ProgOptionsBLL.UpdateOptions(t1);
this.Close();
}
}
//获取指定OptionsID的ProgOptions
public static ProgOptions GetOptions(int i_OptionsID)
{
ISession session = NHibernateHelper.OpenSession();
ProgOptions tClass = new ProgOptions();
try
{
tClass = session.Get <ProgOptions>(i_OptionsID);
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
}
session.Close();
return(tClass);
}
void FormProgOptionLoad(object sender, EventArgs e)
{
//如果是修改，把原来的数据填写进去
if (this.Text == "系统参数-修改")
{
textBoxOptionsID.Text = i_OptionsID.ToString();
ProgOptions tP = BLL.ProgOptionsBLL.GetOptions(i_OptionsID);
textBoxOptionsKey.Text = tP.OptionsKey;
textBoxOptionsValue.Text = tP.OptionsValue;
textBoxOptionsRemark.Text = tP.OptionsRemark;
}
else
{
;
}
this.ActiveControl = textBoxOptionsKey;
}
//修改
public static void UpdateOptions(ProgOptions tp)
{
ISession session = NHibernateHelper.OpenSession();
try
{
ITransaction tx = session.BeginTransaction();
ProgOptions t1 = session.Get <ProgOptions>(tp.OptionsID);
t1.OptionsKey = tp.OptionsKey;
t1.OptionsValue = tp.OptionsValue;
t1.OptionsRemark = tp.OptionsRemark;
tx.Commit();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
}
session.Close();
}
//添加
public static void AddOptions(ProgOptions tp)
{
//ISessionFactory sessionFactory = new Configuration().Configure().BuildSessionFactory();
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
try
{
session.Save(tp);
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
//增加入库单
public static void AddRKD(Receipt tReceipt, List <ReceiptItems> tItemsList)
{
//保存数据，注意使用事务进行处理
//1、入库单号的生成与修改；2、入库单的增加；3入库单项目的增加
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
try
{
//查最后的入库单号
IList <ProgOptions> Key1 = BLL.ProgOptionsBLL.GetOptions("RKD_LastNumber");
string s_RKD_LastNo = Key1[0].OptionsValue;
string s_RKD_NewNo;
string s_RKD_LastYM;
string s_RKD_NewYM;
int LastNo;
int NewNo;
string s_NewNo;
s_RKD_NewYM = DateTime.Today.ToString("yyyyMM");
if (s_RKD_LastNo.Length == 10)
{
//4位年+2位月+4位顺序号
s_RKD_LastYM = s_RKD_LastNo.Substring(0, 6);
LastNo = Convert.ToInt32(s_RKD_LastNo.Substring(6, 4));
if (s_RKD_NewYM != s_RKD_LastYM)
{
NewNo = 1;
}
else
{
NewNo = LastNo + 1;
}
}
else
{
//没有数据
NewNo = 1;
}
s_NewNo = "0000" + NewNo.ToString();
s_NewNo = s_NewNo.Substring(s_NewNo.Length - 4, 4);
//将新的最后编号保存到数据库
ProgOptions t1 = session.Get <ProgOptions>(Key1[0].OptionsID);
t1.OptionsID = Key1[0].OptionsID;
t1.OptionsKey = Key1[0].OptionsKey;
s_RKD_NewNo = s_RKD_NewYM + s_NewNo;
t1.OptionsValue = s_RKD_NewNo;
t1.OptionsRemark = Key1[0].OptionsRemark;
//保存入库单
tReceipt.ReceiptNum = "RKD-" + t1.OptionsValue;
session.Save(tReceipt);
//添加应付款
if (tReceipt.ReceiptDiscAmt != 0)
{
Projects tP1 = session.Get <Projects>(tReceipt.ProjectID);
Companies tC1 = session.Get <Companies>(tReceipt.CompanyID);
AccountBill tAcc = new AccountBill();
tAcc.CompanyID = tReceipt.CompanyID;
tAcc.CompanyName = tC1.CompanyName;
tAcc.BillDate = tReceipt.ReceiptDate;
tAcc.BillMemo = "采购应付款" + tReceipt.ReceiptNum;
tAcc.BillType = 1;
tAcc.BillYF = tReceipt.ReceiptDiscAmt;
tAcc.ProjectID = tReceipt.ProjectID;
tAcc.ProjectName = tP1.ProjectName;
tAcc.MoneyTypeID = 100; //材料购买
tAcc.MoneyTypeName = "入库单生成";
tAcc.BillStatus = "已记账";
session.Save(tAcc);
}
foreach (ReceiptItems tRI in tItemsList)
{
//保存进货项
ReceiptItems tNewReceiptItems = new ReceiptItems();
tNewReceiptItems.GoodsID = tRI.GoodsID;
tNewReceiptItems.ReceiptID = tReceipt.ReceiptID;
tNewReceiptItems.GoodsName = tRI.GoodsName;
tNewReceiptItems.GoodsAmt = tRI.GoodsAmt;
tNewReceiptItems.GoodsPlan = tRI.GoodsPlan;
tNewReceiptItems.GoodsPlanNo = tRI.GoodsPlanNo;
tNewReceiptItems.GoodsPrc = tRI.GoodsPrc;
tNewReceiptItems.GoodsQty = tRI.GoodsQty;
tNewReceiptItems.GoodsSpec = tRI.GoodsSpec;
tNewReceiptItems.GoodsUnit = tRI.GoodsUnit;
tNewReceiptItems.GoodsYF = tRI.GoodsYF;
tNewReceiptItems.GoodsTaxRate = tRI.GoodsTaxRate;
tNewReceiptItems.GoodsNoTaxPrice = tRI.GoodsNoTaxPrice;
tNewReceiptItems.MoreSpec = tRI.MoreSpec;
tNewReceiptItems.UsePosition = tRI.UsePosition;
session.Save(tNewReceiptItems);
}
//入库单同货品合并
List <ReceiptItems> mergeList = new List <ReceiptItems>();
foreach (ReceiptItems tRI in tItemsList)
{
ReceiptItems rtnRItem = mergeList.Find(name =>
{
if (name.GoodsID == tRI.GoodsID)
{
return(true);
}
else
{
return(false);
}
});
if (rtnRItem == null)
{
mergeList.Add(tRI);
}
else
{
rtnRItem.GoodsQty += tRI.GoodsQty;
rtnRItem.GoodsAmt += tRI.GoodsAmt;
if (rtnRItem.GoodsQty != 0)
{
rtnRItem.GoodsPrc = rtnRItem.GoodsAmt / rtnRItem.GoodsQty;
}
}
}
//更新库存
foreach (ReceiptItems tRI in mergeList)
{
PKModel pk = new PKModel();
pk.GoodsID = tRI.GoodsID;
pk.WareHouseID = tReceipt.WareHouseID;
WareHouseStock tWH = session.Get <WareHouseStock>(pk);
if (tWH == null)
{
WareHouseStock tWHNew = new WareHouseStock();
tWHNew.Pk = pk;
tWHNew.Number = tRI.GoodsQty;
tWHNew.LastPrice = tRI.GoodsPrc;
tWHNew.Price = tRI.GoodsPrc;
tWHNew.Amount = tRI.GoodsAmt;
session.Save(tWHNew);
}
else
{
tWH.Number += tRI.GoodsQty;
tWH.Amount += tRI.GoodsAmt;
tWH.LastPrice = tRI.GoodsPrc;
if (tWH.Number != 0)
{
tWH.Price = Math.Round(tWH.Amount / tWH.Number, 2);
}
session.Flush();
}
}
//事务提交
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
//增加出库单
public static void AddCKD(OutStock tOutStock, List <OutStockItems> tItemsList)
{
//保存数据，注意使用事务进行处理
//1、出库单号的生成与修改；2、出库单的增加；3、出库单项目的增加
ISession session = NHibernateHelper.sessionFactory.OpenSession();
ITransaction tx = session.BeginTransaction();
try
{
//查最后的出库单号
IList <ProgOptions> Key1 = BLL.ProgOptionsBLL.GetOptions("CKD_LastNumber");
string s_CKD_LastNo = Key1[0].OptionsValue;
string s_CKD_NewNo;
string s_CKD_LastYM;
string s_CKD_NewYM;
int LastNo;
int NewNo;
string s_NewNo;
s_CKD_NewYM = DateTime.Today.ToString("yyyyMM");
if (s_CKD_LastNo.Length == 10)
{
//4位年+2位月+4位顺序号
s_CKD_LastYM = s_CKD_LastNo.Substring(0, 6);
LastNo = Convert.ToInt32(s_CKD_LastNo.Substring(6, 4));
if (s_CKD_NewYM != s_CKD_LastYM)
{
NewNo = 1;
}
else
{
NewNo = LastNo + 1;
}
}
else
{
//没有数据
NewNo = 1;
}
s_NewNo = "0000" + NewNo.ToString();
s_NewNo = s_NewNo.Substring(s_NewNo.Length - 4, 4);
//将新的最后编号保存到数据库
ProgOptions t1 = session.Get <ProgOptions>(Key1[0].OptionsID);
t1.OptionsID = Key1[0].OptionsID;
t1.OptionsKey = Key1[0].OptionsKey;
s_CKD_NewNo = s_CKD_NewYM + s_NewNo;
t1.OptionsValue = s_CKD_NewNo;
t1.OptionsRemark = Key1[0].OptionsRemark;
//保存出库单
tOutStock.OutStockNum = "CKD-" + t1.OptionsValue;
session.Save(tOutStock);
//保存出库单项
foreach (OutStockItems tOI in tItemsList)
{
tOI.OutStockID = tOutStock.OutStockID;
session.Save(tOI);
//更新库存
PKModel pk = new PKModel();
pk.GoodsID = tOI.GoodsID;
pk.WareHouseID = tOutStock.WareHouseID;
WareHouseStock tWH = session.Get <WareHouseStock>(pk);
if (tWH == null)
{
WareHouseStock tWHNew = new WareHouseStock();
tWHNew.Pk = pk;
tWHNew.Number = -tOI.GoodsQty;
tWHNew.Price = tOI.GoodsPrc;
tWHNew.Amount = -tOI.GoodsAmt;
session.Save(tWHNew);
}
else
{
tWH.Number -= tOI.GoodsQty;
tWH.Amount -= tOI.GoodsAmt;
if (tWH.Number != 0)
{
tWH.Price = Math.Round(tWH.Amount / tWH.Number, 2);
}
session.Flush();
}
}
//事务提交
tx.Commit();
session.Close();
}
catch (Exception e)
{
Debug.Assert(false, e.Message);
tx.Rollback();
session.Close();
}
}
