Esempio n. 1
0
 public static void updateRowCss(string ridx, FineUIPro.Grid grid, string cssname)
 {
     grid.Rows[int.Parse(ridx)].RowCssClass = cssname;
 }
Esempio n. 2
0
        public static string NewPLsendInstruction(string OrderNo, string ProNo, string ProName, string ReceiveDept, string Receiver, string OdtSN, string userid, FineUIPro.Grid grid)
        {
            StringBuilder sql = new StringBuilder();
            ArrayList     al  = new ArrayList();
            string        s   = "";

            SQLHelper.DbHelperSQL.SetConnectionString("");
            foreach (int i in grid.SelectedRowIndexArray)
            {
                s = "select count(*) from Instruction where OrderNo='" + OrderNo + "' and OdtSN=" + OdtSN + " and itemno='" + grid.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='" + grid.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,ConfirmQuantity,RealUsingQuantity,ConfirmDate)");
                sql.Append(" values(");
                sql.Append("'" + OrderNo + "',");
                sql.Append("'" + ProNo + "',");
                sql.Append("'" + ProName + "',");
                sql.Append("'" + grid.Rows[i].Values[2].ToString() + "',");  //ItemNo
                sql.Append("'" + grid.Rows[i].Values[3].ToString() + "',");  //ItemName
                sql.Append("'" + grid.Rows[i].Values[4].ToString() + "',");  //Spec
                sql.Append("'" + grid.Rows[i].Values[5].ToString() + "',");  //Material
                sql.Append("'" + grid.Rows[i].Values[6].ToString() + "',");  //SurfaceDeal
                sql.Append("" + grid.Rows[i].Values[8].ToString() + ",");    //UsingQuantity
                sql.Append("'" + grid.Rows[i].Values[9].ToString() + "',");  //Sclass
                sql.Append("'" + grid.Rows[i].Values[12].ToString() + "',"); //MainFrom


                sql.Append("'" + userid + "',");
                sql.Append("getdate(),");
                sql.Append("1,"); //IsConfirm
                sql.Append("0,"); //IsPlan

                sql.Append("'" + ReceiveDept + "',");
                sql.Append("'" + Receiver + "',");
                System.Threading.Thread.Sleep(1);
                sql.Append("'" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + "',");
                sql.Append(grid.DataKeys[i][0] + ",");
                sql.Append(OdtSN + ",");
                sql.Append("0,");                                         //ConfirmQuantity
                sql.Append("" + grid.Rows[i].Values[8].ToString() + ","); //RealUsingQuantity
                sql.Append("getdate()");                                  //ConfirmDate
                sql.Append(")");
                al.Add(sql.ToString());
                //FileOper.writeLog(sql.ToString());
                FileOper.writeLog(sql.ToString());
            }

            if (SQLHelper.DbHelperSQL.ExecuteSqlTran(al))
            {
                return("发送成功");
            }
            else
            {
                return("发送失败");
            }
        }