protected void btnPLSend_Click(object sender, EventArgs e)
{
try
{
if (Grid2.GetModifiedData().Count != 0 || Grid2.GetNewAddedList().Count != 0)
{
Alert.Show("表格还有未保存的数据，请先保存！");
return;
}
if (Grid2.SelectedRowIndexArray.Length == 0)
{
Alert.Show("请选择物料");
return;
}
string orderno = "", prono = "", pname = "";
orderno = GetQueryValue("od");
prono = GetQueryValue("ProNo");
pname = GetQueryValue("ItemName");
string OdtSN = GetQueryValue("sn");
Alert.Show(CommFunction.PLsendInstruction(orderno, prono, pname, ddlDept.SelectedText, ddlUser.SelectedValue, OdtSN, User.Identity.Name, Grid2));
#region bak
//string OdtSN = GetQueryValue("sn");
//StringBuilder sql = new StringBuilder();
//ArrayList al = new ArrayList();
//SQLHelper.DbHelperSQL.SetConnectionString("");
//foreach (int i in Grid2.SelectedRowIndexArray)
//{
// s = "select count(*) from Instruction where OrderNo='" + orderno + "' and OdtSN=" + OdtSN + " and itemno='" + Grid2.Rows[i].Values[2].ToString() + "' and IsConfirm=0";
// if (int.Parse(SQLHelper.DbHelperSQL.GetSingle(s, 30)) > 0)
// {
// continue;
// }
// s = "select (case when sum(ConfirmQuantity) is null then 0 else sum(ConfirmQuantity) end) from instruction where orderno='" + orderno + "' and OdtSN=" + OdtSN + " and itemno='" + Grid2.Rows[i].Values[2].ToString() + "'";
// sql.Clear();
// sql.Append("insert into Instruction(OrderNo,ProNo,ProName,ItemNo,ItemName,Spec,Material,SurfaceDeal,UsingQuantity,Sclass,MainFrom,Inputer,InputeDate,IsConfirm,IsPlan,ReceiveDept,Receiver,BarCode,BomSN,OdtSN)");
// sql.Append(" values(");
// sql.Append("'" + orderno + "',");
// sql.Append("'" + prono + "',");
// sql.Append("'" + pname + "',");
// sql.Append("'" + Grid2.Rows[i].Values[2].ToString() + "',");//ItemNo
// sql.Append("'" + Grid2.Rows[i].Values[3].ToString() + "',");//ItemName
// sql.Append("'" + Grid2.Rows[i].Values[4].ToString() + "',");//Spec
// sql.Append("'" + Grid2.Rows[i].Values[5].ToString() + "',");//Material
// sql.Append("'" + Grid2.Rows[i].Values[6].ToString() + "',");//SurfaceDeal
// sql.Append("" + Grid2.Rows[i].Values[8].ToString() + "-(" + s + "),");//UsingQuantity
// sql.Append("'" + Grid2.Rows[i].Values[9].ToString() + "',");//Sclass
// sql.Append("'" + Grid2.Rows[i].Values[12].ToString() + "',");//MainFrom
// sql.Append("'" + User.Identity.Name + "',");
// sql.Append("getdate(),");
// sql.Append("0,");
// sql.Append("0,");
// sql.Append("'" + ddlDept.SelectedText + "',");
// sql.Append("'" + ddlUser.SelectedValue + "',");
// sql.Append("'" + DateTime.Now.ToString("yyyyMMddHHmmsss") + i.ToString() + "',");
// sql.Append(Grid2.DataKeys[i][0] + ",");
// sql.Append(OdtSN);
// sql.Append(")");
// al.Add(sql.ToString());
// //log.Info(sql.ToString());
// FileOper.writeLog(sql.ToString());
//}
//if (SQLHelper.DbHelperSQL.ExecuteSqlTran(al))
//{
// Alert.Show("发送成功");
// BindGrid2();
//}
//else
//{
// Alert.Show("发送失败");
//}
#endregion
}
catch (Exception ee)
{
Alert.Show(ee.ToString());
}
}