public void GetWarehouseInfo(ref ComboBox CB)
{
WeighingDBlayer dbLayer = new WeighingDBlayer();
CB.DataSource = dbLayer.SelectWarehouseInfo();
CB.DisplayMember = "fullName";
CB.SelectedIndex = -1;
CB.ValueMember = "id";
}
public void GetProductModel(string name, ref ComboBox cb)
{
DataTable dt = new DataTable();
WeighingDBlayer dbLayer = new WeighingDBlayer();
dt = dbLayer.SelectproductModel(name);
cb.DataSource = dt;
cb.DisplayMember = "model";
cb.SelectedIndex = -1;
cb.ValueMember = "id";
}
public void GetMateriaName(ref ComboBox cb)
{
DataTable dt = new DataTable();
WeighingDBlayer dbLayer = new WeighingDBlayer();
dt = dbLayer.SelectMaterialName();
cb.DataSource = dt;
cb.DisplayMember = "name";
cb.SelectedIndex = -1;
cb.ValueMember = "id";
}
/*
* 方法名称：GetTruckNoItem
* 方法功能描述：取得车牌号列表
* 参数:
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-04
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void GetTruckNoItem(ref ComboBox CB)
{
WeighingDBlayer dbLayer = new WeighingDBlayer();
DataTable dt = new DataTable();
dt = dbLayer.SelectTruckInfo("");
CB.DataSource = dt;
CB.DisplayMember = "no";
CB.SelectedIndex = -1;
CB.ValueMember = "id";
}
/*
* 方法名称：GetSite1
* 方法功能描述：取得启运地或止运地
* 参数: cb 用于存放列表的下拉框
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-04
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void GetSite(ref ComboBox cb1)
{
WeighingDBlayer dblayer = new WeighingDBlayer();
DataTable bt = new DataTable();
bt = dblayer.SelectSite();
cb1.DataSource = bt;
cb1.DisplayMember = "site";
cb1.SelectedIndex = -1;
cb1.ValueMember = "id";
}
public void GetSiteValue(string tgicId, ref ComboBox cb1, ref ComboBox cb2)
{
WeighingDBlayer dbLayer = new WeighingDBlayer();
DataTable dt = new DataTable();
dt = dbLayer.SelectSiteValue(tgicId);
if (dt.Rows.Count > 0)
{
cb1.Text = dt.Rows[0]["sname1"].ToString();
cb2.Text = dt.Rows[0]["sname2"].ToString();
}
}
/*
* 方法名称：GetOwner
* 方法功能描述：查询车主姓名
* 参数: truckNo 车牌号
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-05
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public string GetOwner(string truckNo)
{
WeighingDBlayer dblayer = new WeighingDBlayer();
DataTable bt = new DataTable();
string Rec = "";
bt = dblayer.SelectTruckInfo(truckNo);
if ((!bt.Equals(null)) && (bt.Rows.Count > 0))
{
Rec = bt.Rows[0]["owner"].ToString();
}
return(Rec);
}
/*
* 方法名称：GetTransportContract
* 方法功能描述：取得运输合同列表
* 参数: cb 用于存放列表的下拉框
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-04
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void GetTransportInfo(string style, ref ComboBox cb)
{
WeighingDBlayer dblayer = new WeighingDBlayer();
DataTable bt = new DataTable();
switch (style)
{
case "入库称重":
bt = dblayer.SelectTransportMaterialInfo();
cb.DataSource = bt;
cb.DisplayMember = "contractName";
cb.SelectedIndex = -1;
cb.ValueMember = "id";
break;
case "出库称重":
bt = dblayer.SelectTransportProductInfo();
cb.DataSource = bt;
cb.DisplayMember = "contractName";
cb.SelectedIndex = -1;
cb.ValueMember = "id";
break;
}
}
/*
* 方法名称：GetTruckInfo
* 方法功能描述：通过车牌号取得车辆信息
* 参数:
* 返回:
* 创建人：袁宇
* 创建时间：2009-03-04
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public DataTable GetTruckInfo(string truckNo)
{
WeighingDBlayer dbLayer = new WeighingDBlayer();
return(dbLayer.SelectTruckInfo(truckNo));
}
