//private void TransDatatoView(DataTable dtDisplay1,DataTable dtDisplay2)
//{
// Devices devices = new Devices();
// DeviceCrkManage dcm = new DeviceCrkManage();
// //传入备件仪表ID信息，输出该ID对应的所有信息
// devices = dcm.CxInfofromdatabase(this.txtById.Text);
// dtDisplay2.Rows.Add(new string[] {devices.DEVICEID, this.grpCz.Text, dtpCz.Value.ToString(), devices.DEVICENAME });
// dtDisplay1.Merge(dtDisplay2);
// try
// {
// if (this.grpCz.Text != "")
// {
// if(devices!=null)
// {
// this.dgvByCrkInfo.DataSource = dtDisplay1;
// }
// else
// {
// ShowAlertMessage("该设备号不正确，请重新输入！");
// }
// }
// else
// {
// ShowAlertMessage("请先登录!");
// }
// }
// catch(Exception e)
// {
// throw e;
// }
//}
#endregion
//将从数据库中读取以及控件中的数据显示在datagridview控件dgvByCrkInfo中
private void TransDatatoView(int typenumber)
{
//BJTable bjtable = new BJTable();
//HCTable hcttable = new HCTable();
//YBTools ybtools = new YBTools();
//Devices devices = new Devices();
DeviceCrkManage dcm = new DeviceCrkManage();
//DataTable dt = new DataTable();
//传入备件仪表ID信息，输出该ID对应的所有信息
dt = dcm.CxInfofromdatabase(this.txtById.Text, typenumber);
try
{
if (this.grpCz.Text != "")
{
if (dt != null)
{
int index = this.dgvByCrkInfo.Rows.Add();
this.dgvByCrkInfo.Rows[index].Cells[0].Value = index + 1;
this.dgvByCrkInfo.Rows[index].Cells[1].Value = dt.Rows[0][0].ToString().Trim();
this.dgvByCrkInfo.Rows[index].Cells[2].Value = this.grpCz.Text;
this.dgvByCrkInfo.Rows[index].Cells[3].Value = dtpCz.Value.ToString();
this.dgvByCrkInfo.Rows[index].Cells[4].Value = dt.Rows[0][1].ToString().Trim();
}
else
{
ShowAlertMessage("该设备号不正确，请重新输入！");
}
}
else
{
ShowAlertMessage("请先登录!");
}
}
catch (Exception e)
{
throw e;
}
}
private void btnRk_Click(object sender, EventArgs e)
{
DeviceCrkManage dcm = new DeviceCrkManage();
ArrayList errorlist = new ArrayList();//datagridview中没有完成导入的条目将会被存入该可变数组中
string errormessage = null;
string ckorrk = "r";
string id = "0";
int hcnum = Convert.ToInt32(this.txtHcnum.Text.ToString());
for (int i = 0; i < dgvByCrkInfo.Rows.Count - 1; i++)
{
id = dgvByCrkInfo.Rows[i].Cells[1].Value.ToString().Trim();
bool rzisnotsuccess = dcm.UpdateInfotodatebase(ckorrk, typenumber, id, hcnum);//出库是否成功bool值
if (rzisnotsuccess)
{
}
else
{
//ShowAlertMessage("请确保你的数据库中存在该项目：" + id);
errorlist.Add(id);
}
}
if (errorlist.Count == 0)
{
ShowAlertMessage("入库成功！");
}
else
{
foreach (int i in errorlist)
{
errormessage = errormessage + errorlist[i] + ",";
}
ShowAlertMessage(errormessage + "上述编号的物品已在仓库中，请不要重复入库！");
}
}
