//入库（手动输入生产日期）
public static bool AddGoods(GoodsIn goodsin, DateTime producedate)
{
//判断商品ID是否存在
string sql = "select * from goods where G_ID='" + goodsin.G_ID + "'";
OdbcConnection odbcConnection = DBManager.GetOdbcConnection();
odbcConnection.Open();
OdbcCommand odbcCommand = new OdbcCommand(sql, odbcConnection);
OdbcDataReader odbcDataReader = odbcCommand.ExecuteReader(CommandBehavior.CloseConnection);
if (!odbcDataReader.HasRows)//商品ID不存在 返回空
{
return(false);
}
//商品ID存在 插入
bool flag;
goodsin.GI_ID = IDFormat.getID_8();
String insertSql = String.Format("insert into `marketmanage`.`goodsin` (`GI_ID`, `G_ID`,`S_ID`,`GI_PriceIn`,`GI_Num`,`GI_Date`,`GI_OriginPlace`) " +
"values ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')"
, goodsin.GI_ID, goodsin.G_ID, goodsin.S_ID, goodsin.PriceIn, goodsin.Num, goodsin.Date, goodsin.OriginPlace);
flag = ExecuteSQL.ExecuteNonQuerySQL_GetBool(insertSql);
//更新库存表
if (!flag)
{
return(false);
}
string update_storelist = String.Format("insert into `marketmanage`.`storelist` (`G_ID`,`GI_ID`,`SL_Num`,`SL_ProducedDate`) values ('{0}','{1}','{2}','{3}')"
, goodsin.G_ID, goodsin.GI_ID, goodsin.Num, producedate);
flag = ExecuteSQL.ExecuteNonQuerySQL_GetBool(update_storelist);
//更新商品表（库存数量）
if (!flag)
{
return(false);
}
String update_goods = "update Goods set G_Store=G_Store+" + goodsin.Num + " where G_ID='" + goodsin.G_ID + "'";
flag = ExecuteSQL.ExecuteNonQuerySQL_GetBool(update_goods);
return(flag? true : false);
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
goodsIn = new GoodsIn("123", gid.Value, Convert.ToInt32(sid.Value), Convert.ToDouble(gprice.Value), Convert.ToDouble(gnum.Value), DateTime.Now, gplace.Value);
DateTime s = Convert.ToDateTime(gdate.Value);
bool result = GoodsIn_C.AddGoods(goodsIn, s);
if (result)
{
Response.Write("<script language=javascript>window.alert('入库成功');</script>");
}
else
{
Response.Write("<script language=javascript>window.alert('添加失败！');</script>");
}
}
catch(Exception em)
{
Response.Write("<script language=javascript>window.alert('添加失败！');</script>");
}
}
//详细入库信息
public static List <GoodsIn> GetGoodsIn_ListsByG_ID(string G_ID = "")
{
string sql = "select `googsin`.`GI_ID`,`goodsin`.`G_ID`,`goodsin`.`S_ID`,`goodsin`.`GI_PriceIn`,`goodsin`.`GI_Num`,`goodsin`.`GI_Date`,`goodsin`.`GI_OriginPrice` "
+ "from `goodsin` "
+ "where `goodsin`.`G_ID` =`" + G_ID + "`"
+ "order by G_ID";
OdbcConnection odbcConnection = DBManager.GetOdbcConnection();
odbcConnection.Open();
OdbcCommand odbcCommand = new OdbcCommand(sql, odbcConnection);
OdbcDataReader odbcDataReader = odbcCommand.ExecuteReader();
if (odbcDataReader.HasRows)
{
List <GoodsIn> list = GoodsIn.getList(odbcDataReader);
odbcConnection.Close();
return(list);
}
odbcConnection.Close();
return(null);
}
public string InGoods(string id, decimal num)
{
lock (obj)
{
using (IGenericTransaction tx = this.m_UnitOfWork.BeginTransaction())
{
try
{
Purchase p = this.Get(Convert.ToInt32(id));
if (ps == null)
{
ps = new PublicService();
}
//数量累加
PurchaseMain pm = p.PurchaseMain;
if (pm == null)
{
tx.Rollback();
return("找不到PurchaseMain数据。");
}
pm.Main_num1 += num;
ps.PurchaseMain.Update(pm);
//修改数量
if (p == null)
{
return("找不到ID为" + id + "的信息");
}
if (p.Purchase_Num < p.Purchase_Num1 + num)
{
return("超过额定量");
}
if (p.Purchase_State == 1)
{
return("任务已经完成");
}
p.Purchase_Num1 += num;
if (p.Purchase_Num == p.Purchase_Num1)//满表示完成了
{
p.Purchase_State = 1;
if (p.PurchaseContracts != null)
{
//更新合同完成
p.PurchaseContracts[0].PurchaseContract_state = 1;
this.ps.PurchaseConstract.Update(p.PurchaseContracts[0]);
}
}
this.Update(p);
//入库存 AddByPurchase方法有写库存
//GoodsInfo ginfo = this.m_UnitOfWork.GetRepositoryBase<GoodsInfo>().Query().Where(m => m.ID == p.GoodsID).FirstOrDefault();
//if (ginfo == null)
//{
// tx.Rollback();
// return "找不到" + p.GoodsID + "的物资";
//}
//ginfo.ContentNum += num;
//this.ps.GoodsInfo.Update(ginfo);
//入库信息
GoodsIn gIn = new GoodsIn();
gIn.GoodsID = p.GoodsID;
gIn.InNum = num;
gIn.SupplyName = p.PurchaseContracts[0].PurchaseContract_Supply;
gIn.InPrice = p.Purchase_Price;
gIn.InTime = DateTime.Now;
gIn.Operator = AuthorizationService.CurrentUserID;
gIn.TransportName = p.PurchaseContracts[0].PurchaseContract_Supply1;
if (p.PurchaseContracts != null)
{
//添加合同
gIn.PurchaseContract_ID = p.PurchaseContracts[0].ID;
gIn.PurchaseContract_Name = p.PurchaseContracts[0].PurchaseContract_Name;
}
this.ps.GoodsIn.AddByPurchase(gIn);
tx.Commit();
return("");
}
catch (Exception e)
{
tx.Rollback();
return(e.Message);
}
}
}
}
private string encryptkey = "Oyea"; //密钥
#region 执行“目录”控件中的项操作
/// <summary>
/// 执行“目录”控件中的项操作
/// </summary>
/// <param name="control">控件类型</param>
/// <param name="form">所属窗体</param>
public void ShowForm(ToolStripMenuItem control, Form form)
{
switch (control.Tag.ToString())
{
case "1":
EmployeeInfo employee = new EmployeeInfo();
employee.MdiParent = form;
employee.StartPosition = FormStartPosition.CenterScreen;
employee.Show();
break;
case "2":
CompanyInfo company = new CompanyInfo();
company.MdiParent = form;
company.StartPosition = FormStartPosition.CenterScreen;
company.Show();
break;
case "3":
Login login = new Login();
login.StartPosition = FormStartPosition.CenterScreen;
login.ShowDialog();
form.Dispose(); //释放窗体资源
break;
case "5":
GoodsIn goodsin = new GoodsIn();
goodsin.MdiParent = form;
goodsin.StartPosition = FormStartPosition.CenterScreen;
goodsin.Show();
break;
case "6":
ReGoods regoods = new ReGoods();
regoods.MdiParent = form;
regoods.StartPosition = FormStartPosition.CenterScreen;
regoods.Show();
break;
case "7":
GoodsFind stockfind = new GoodsFind();
stockfind.MdiParent = form;
stockfind.StartPosition = FormStartPosition.CenterScreen;
stockfind.Show();
break;
case "8":
s sellgoods = new s();
sellgoods.MdiParent = form;
sellgoods.StartPosition = FormStartPosition.CenterScreen;
sellgoods.Show();
break;
case "9":
CustomerReGoods customerregoods = new CustomerReGoods();
customerregoods.MdiParent = form;
customerregoods.StartPosition = FormStartPosition.CenterScreen;
customerregoods.Show();
break;
case "10":
SellFind sellfind = new SellFind();
sellfind.MdiParent = form;
sellfind.StartPosition = FormStartPosition.CenterScreen;
sellfind.Show();
break;
case "11":
ChangeGoods changegoods = new ChangeGoods();
changegoods.MdiParent = form;
changegoods.StartPosition = FormStartPosition.CenterScreen;
changegoods.Show();
break;
case "12":
StockAlarm stockalarm = new StockAlarm();
stockalarm.MdiParent = form;
stockalarm.StartPosition = FormStartPosition.CenterScreen;
stockalarm.Show();
break;
case "13":
StockFind stockfindall = new StockFind();
stockfindall.MdiParent = form;
stockfindall.StartPosition = FormStartPosition.CenterScreen;
stockfindall.Show();
break;
case "14":
EmployeeReport employeereport = new EmployeeReport();
employeereport.MdiParent = form;
employeereport.StartPosition = FormStartPosition.CenterScreen;
employeereport.Show();
break;
case "15":
CompanyReport companyreport = new CompanyReport();
companyreport.MdiParent = form;
companyreport.StartPosition = FormStartPosition.CenterScreen;
companyreport.Show();
break;
case "16":
GoodsInReport goodsinreport = new GoodsInReport();
goodsinreport.MdiParent = form;
goodsinreport.StartPosition = FormStartPosition.CenterScreen;
goodsinreport.Show();
break;
case "17":
GoodsInAnalysisReport sellgodsreport = new GoodsInAnalysisReport();
sellgodsreport.MdiParent = form;
sellgodsreport.StartPosition = FormStartPosition.CenterScreen;
sellgodsreport.Show();
break;
case "18":
EmployeeSellReport employeesellreport = new EmployeeSellReport();
employeesellreport.MdiParent = form;
employeesellreport.StartPosition = FormStartPosition.CenterScreen;
employeesellreport.Show();
break;
case "19":
GoodsInAnalysisReport goodsinana = new GoodsInAnalysisReport();
goodsinana.MdiParent = form;
goodsinana.StartPosition = FormStartPosition.CenterScreen;
goodsinana.Show();
break;
case "20":
SellGoodsAnalysisReport sellana = new SellGoodsAnalysisReport();
sellana.MdiParent = form;
sellana.StartPosition = FormStartPosition.CenterScreen;
sellana.Show();
break;
case "21":
SetPopedom setpopedom = new SetPopedom();
setpopedom.MdiParent = form;
setpopedom.StartPosition = FormStartPosition.CenterScreen;
setpopedom.Show();
break;
case "22":
ChangePwd changepwd = new ChangePwd();
changepwd.MdiParent = form;
changepwd.StartPosition = FormStartPosition.CenterScreen;
changepwd.Show();
break;
case "23":
BakData bakdata = new BakData();
bakdata.MdiParent = form;
bakdata.StartPosition = FormStartPosition.CenterScreen;
bakdata.Show();
break;
case "24":
ReBakData rebakdata = new ReBakData();
rebakdata.MdiParent = form;
rebakdata.StartPosition = FormStartPosition.CenterScreen;
rebakdata.Show();
break;
case "25":
SysUser sysuser = new SysUser();
sysuser.MdiParent = form;
sysuser.StartPosition = FormStartPosition.CenterScreen;
sysuser.Show();
break;
case "30":
CustomerInfo customer = new CustomerInfo();
customer.MdiParent = form;
customer.StartPosition = FormStartPosition.CenterScreen;
customer.Show();
break;
case "31":
EmployeeSellAnalysisReport sell = new EmployeeSellAnalysisReport();
sell.MdiParent = form;
sell.StartPosition = FormStartPosition.CenterScreen;
sell.Show();
break;
default:
break;
}
}
