/*
* 方法名称：SetGoodsModel
* 方法功能描述：取得物品型号列表
* 参数: option 确定出入库 scid 合同信息ID cb 存列表的下拉 name 物品名称
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-05
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void SetGoodsModel(string option, string scid, string name, ref ComboBox cb)
{
DataTable dt = new DataTable();
switch (option)
{
case "入库称重":
InWeighingDBLayer dblayer1 = new InWeighingDBLayer();
dt = dblayer1.SelectIndent(scid, name);
cb.DataSource = dt;
cb.DisplayMember = "model";
cb.ValueMember = "id";
break;
case "出库称重":
OutWeighingDBLayer dblayer2 = new OutWeighingDBLayer();
dt = dblayer2.SelectInvoice(scid, name);
cb.DataSource = dt;
cb.DisplayMember = "model";
cb.ValueMember = "id";
break;
default:
;
break;
}
}
/*
* 方法名称：GetContractItem
* 方法功能描述：取得合同列表
* 参数: option 用于确定是销售合同，还是采购合同，取值：入库称重、出库称重
* 返回: DataTable
* 创建人：袁宇
* 创建时间：2009-03-04
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void GetContractItem(string option, ref ComboBox box)
{
switch (option)
{
case "入库称重":
InWeighingDBLayer dblayer1 = new InWeighingDBLayer();
DataTable dt1 = new DataTable();
dt1 = dblayer1.SelectStockContract();
box.DataSource = dt1;
box.DisplayMember = "name";
box.SelectedIndex = -1;
box.ValueMember = "id";
break;
case "出库称重":
OutWeighingDBLayer dblayer2 = new OutWeighingDBLayer();
DataTable dt2 = new DataTable();
dt2 = dblayer2.SelectsellContract();
box.DataSource = dt2;
box.DisplayMember = "name";
box.SelectedIndex = -1;
box.ValueMember = "id";
break;
default:
;
break;
}
}
public DataTable FindInInfo(FindCondClass conds)
{
DataTable dt = new DataTable();
InWeighingDBLayer dbLayer = new InWeighingDBLayer();
dt = dbLayer.SelectInInfo(conds);
return(dt);
}
private void button2_Click(object sender, EventArgs e)
{
FrmCodingAdd frmCodingAdd = new FrmCodingAdd();
frmCodingAdd.ShowDialog();
CBBarCode.Text = frmCodingAdd.CodingNo;
if (recordId != -1)
{
switch (style)
{
case WeighingStyle.InStyle:
InWeighingClass info1 = new InWeighingClass();
InWeighingDBLayer dbLayer1 = new InWeighingDBLayer();
info1.Id = recordId.ToString();
info1.BarCode = frmCodingAdd.CodingNo;
if (dbLayer1.UpdateInfo(info1))
{
ClearValue();
CBTruckNo.SelectedIndex = -1;
}
else
{
MessageBox.Show("条码保存有问题！");
}
break;
case WeighingStyle.OutStyle:
OutWeighingClass info2 = new OutWeighingClass();
OutWeighingDBLayer dbLayer2 = new OutWeighingDBLayer();
info2.Id = recordId.ToString();
info2.BarCode = frmCodingAdd.CodingNo;
if (dbLayer2.UpdateInfo(info2))
{
ClearValue();
CBTruckNo.SelectedIndex = -1;
}
else
{
MessageBox.Show("条码保存有问题！");
}
break;
default:
break;
}
}
}
public bool UpdateIninfo(InWeighingClass info)
{
InWeighingDBLayer dbLayer = new InWeighingDBLayer();
DataTable dt = new DataTable();
if (dbLayer.UpdateInfo(info))
{
return(true);
}
else
{
return(false);
}
}
private void button4_Click(object sender, EventArgs e)
{
InWeighingDBLayer dbLayer = new InWeighingDBLayer();
DataSet ds = new DataSet();
DataTable stockNote = new DataTable("stockNote");
stockNote = dbLayer.GetInWeighingReport(recordId.ToString());
//ds.ReadXml(Application.StartupPath + @"\TestData.xml");
ds.Tables.Add(stockNote);
ReportViewer frmRPT = new ReportViewer();
frmRPT.MainDataSet = ds;
frmRPT.ReportName = "stockNote";
ArrayList dsName = new ArrayList();
dsName.Add("DataSet1_stockNote");
frmRPT.MainDataSourceName = dsName;
frmRPT.ReportPath = Application.StartupPath + @"\Report1.rdlc";
frmRPT.ShowDialog();
//button4.Enabled = false;
}
/*
* 方法名称：FindWeighingInfo
* 方法功能描述：查询未称重结束信息
* 参数: option 出入厂标识 truckId 车号Id
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-06
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public DataTable FindWeighingInfo(string option, string truckId)
{
switch (option)
{
case "入库称重":
InWeighingDBLayer dblayer1 = new InWeighingDBLayer();
DataTable dt1 = new DataTable();
dt1 = dblayer1.SelectinWeighInfo(truckId);
return(dt1);
//break;
case "出库称重":
OutWeighingDBLayer dblayer2 = new OutWeighingDBLayer();
DataTable dt2 = new DataTable();
dt2 = dblayer2.SelectOutWeighInfo(truckId);
return(dt2);
//break;
default:
return(null);
// break;
}
}
/*
* 方法名称：SetProvider
* 方法功能描述：查询供应商或客户信息
* 参数: option 确定出入库 scid 合同信息ID cb 存列表的下拉
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-05
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void SetProvider(string option, string scId, ref ComboBox cb)
{
DataTable dt = new DataTable();
switch (option)
{
case "入库称重":
InWeighingDBLayer dblayer1 = new InWeighingDBLayer();
dt = dblayer1.SelectProvider(scId);
cb.Text = dt.Rows[0]["name2"].ToString();
break;
case "出库称重":
OutWeighingDBLayer dblayer2 = new OutWeighingDBLayer();
dt = dblayer2.SelectClientInfo(scId);
cb.Text = dt.Rows[0]["name2"].ToString();
break;
default:
;
break;
}
}
/*
* 方法名称：SaveInInfo
* 方法功能描述：保存入厂称重信息
* 参数: info 信息内容光
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-06
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public bool SaveInInfo(InWeighingClass info, out long recId)
{
InWeighingDBLayer dbLayer = new InWeighingDBLayer();
DataTable dt = new DataTable();
dt = dbLayer.SelectinWeighInfo(info.ViId);
if ((!dt.Equals(null)) && (dt.Rows.Count > 0))
{
//更新
info.Id = dt.Rows[0]["id"].ToString();
if (dbLayer.UpdateInfo(info))
{
recId = Convert.ToInt64(info.Id);
return(true);
}
else
{
recId = -1;
return(false);
}
}
else
{
//新增
if (dbLayer.InsertInfo(info))
{
recId = dbLayer.GetMaxInRecId();
return(true);
}
else
{
recId = -1;
return(false);
}
}
}
public bool checkupInInfo(InWeighingClass info)
{
InWeighingDBLayer dbLayer = new InWeighingDBLayer();
return(dbLayer.UpdateInfo(info));
}
