/*
* 方法名称：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;
}
}
/*
* 方法名称：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;
}
}
public DataTable FindOutInfo(FindCondClass conds)
{
DataTable dt = new DataTable();
OutWeighingDBLayer dbLayer = new OutWeighingDBLayer();
dt = dbLayer.SelectOutInfo(conds);
return(dt);
}
/*
* 方法名称：GetEquipmentItem
* 方法功能描述：取得生产设备列表
* 参数: cb 用于存放列表的下拉框
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-04
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void GetEquipmentItem(ref ComboBox cb)
{
OutWeighingDBLayer dblayer = new OutWeighingDBLayer();
cb.DataSource = dblayer.SelectEquipmentInfo();
cb.DisplayMember = "names";
cb.SelectedIndex = -1;
cb.ValueMember = "id";
}
/*
* 方法名称：GetProjectName
* 方法功能描述：查询工程项目
* 参数: truckNo 车牌号
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-05
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void GetProjectName(ref ComboBox cb)
{
OutWeighingDBLayer dblayer = new OutWeighingDBLayer();
DataTable bt = new DataTable();
bt = dblayer.SelectProjectName();
cb.DataSource = bt;
cb.DisplayMember = "projectName";
cb.SelectedIndex = -1;
cb.ValueMember = "id";
}
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 UpdateOutinfo(OutWeighingClass info)
{
OutWeighingDBLayer dbLayer = new OutWeighingDBLayer();
DataTable dt = new DataTable();
if (dbLayer.UpdateInfo(info))
{
return(true);
}
else
{
return(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;
}
}
/*
* 方法名称：SaveOutInfo
* 方法功能描述：保存出厂称重信息
* 参数: info 信息内容光
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-06
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public bool SaveOutInfo(OutWeighingClass info, out long recId)
{
OutWeighingDBLayer dbLayer = new OutWeighingDBLayer();
DataTable dt = new DataTable();
dt = dbLayer.SelectOutWeighInfo(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 checkupOutInfo(OutWeighingClass info)
{
OutWeighingDBLayer dbLayer = new OutWeighingDBLayer();
return(dbLayer.UpdateInfo(info));
}
