//更新SAP日志
public void uptSapLog(string sTmpNo, string[] sArray)
{
string strTmpTable, strTmpField, strTmpValue;
strTmpTable = "IT_SAPLOG";
strTmpField = "FS_MATERIALNO,FS_MOVETYPE,FS_DESCRIBE,FS_ORDERNO,FS_BATCHNO,FD_UPLOADTIME,"
+ "FN_UPLOADNUM,FS_USER,FS_USERNO,FS_ITEMNO,FD_STARTTIME,FD_ENDTIME";
strTmpValue = "";
for (int i = 0; i < sArray.Length - 1; i++)
{
if (i == 0)
{
strTmpValue = "'" + sArray[i] + "'";
}
else
{
strTmpValue += ",'" + sArray[i] + "'";
}
}
strTmpValue += ",'" + Convert.ToDateTime(objBi.GetServerTime()).ToString("yyyy-MM-dd HH:mm:ss") + "'";
CoreClientParam ccpLog = new CoreClientParam();
ccpLog.ServerName = "ygjzjl.base.QueryData";
ccpLog.MethodName = "insertDataInfo";
ccpLog.ServerParams = new object[] { strTmpTable, strTmpField, strTmpValue };
this.ExecuteNonQuery(ccpLog, CoreInvokeType.Internal);
}
private void upLoadData()
{
if (uGridData.Rows.Count == 0)
{
lstHint2.Items.Add("错误：没有需要上传的数据！");
return;
}
if (ckSC.Checked)
{
MessageBox.Show("查询模式为【已上传】，不允许进行上传操作！");
return;
}
if (!ckQR.Checked)
{
MessageBox.Show("只有查询模式为【已确认】，才允许进行上传操作！");
return;
}
if (uGridData.Rows[0].Cells["FS_RECEIVEFLAG"].Value.ToString() == "0")
{
MessageBox.Show("你可能没有执行查询操作！");
return;
}
if (!chkStoveNo())
{
return;
}
string strTmpLh = "";
byte iFlag = 0;
string strTmpRfc, strTmpCode, strTmpOrder;
string strTmpNo = "";
decimal dTmpZl = 0;
string[] strTmpHeader = new string[] { "", "", "" };
string[] strTmpUpload = new string[] { "", "", "", "", "", "", "", "", "", "", "", "" };
ArrayList listItem = new ArrayList();
ArrayList listSubItem = new ArrayList();
CoreClientParam ccp = new CoreClientParam();
strTmpRfc = "BAPI_GOODSMVT_CREATE";
strTmpCode = "02";
strTmpOrder = "";
for (int i = 0; i < uGridData.Rows.Count; i++)
{
if ((uGridData.Rows[i].Cells["FS_RECEIVEFLAG"].Value.ToString() == "1") && (uGridData.Rows[i].Cells["FS_UPLOADFLAG"].Value.ToString() == "0"))
{
if (uGridData.Rows[i].Cells["FS_AUDITOR"].Value.ToString() == "")
{
lstHint2.Items.Add("第" + i.ToString() + "行数据炼钢未审核！操作终止。");
return;
}
if (iFlag == 0)
{
strTmpHeader[0] = Convert.ToDateTime(uGridData.Rows[i].Cells["FS_ACCOUNTDATE"].Value).ToString("yyyy.MM.dd");
strTmpHeader[1] = Convert.ToDateTime(uGridData.Rows[i].Cells["FS_ACCOUNTDATE"].Value).ToString("yyyy.MM.dd");
strTmpHeader[2] = "";
listSubItem.Add("PTS000"); //物料编号
//listSubItem.Add("BHRB400180011");
listSubItem.Add(uGridData.Rows[i].Cells["FS_RECEIVEFACTORY"].Value.ToString()); //工厂
listSubItem.Add(uGridData.Rows[i].Cells["FS_RECEIVESTORE"].Value.ToString()); //库存地点
//listSubItem.Add("1004000101");//批次
listSubItem.Add(""); //批次
listSubItem.Add("101"); //移动类型101
listSubItem.Add(""); //库存类型
listSubItem.Add(""); //特殊库存标识
strTmpUpload[0] = "PTS000";
strTmpUpload[1] = "101";
strTmpUpload[3] = uGridData.Rows[i].Cells["FS_PRODUCTNO"].Value.ToString();
strTmpUpload[4] = uGridData.Rows[i].Cells["FS_STOVESEATNO"].Value.ToString();
strTmpUpload[5] = Convert.ToDateTime(objBi.GetServerTime()).ToString("yyyy-MM-dd HH:mm:ss");
strTmpUpload[7] = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
strTmpUpload[8] = CoreFS.SA06.CoreUserInfo.UserInfo.GetUserID();
strTmpUpload[9] = uGridData.Rows[i].Cells["FS_ITEMNO"].Value.ToString();
strTmpUpload[10] = strTmpUpload[5];
strTmpOrder = uGridData.Rows[i].Cells["FS_PRODUCTNO"].Value.ToString();
iFlag = 1;
}
dTmpZl += Convert.ToDecimal(uGridData.Rows[i].Cells["FN_NETWEIGHT"].Value);
if (strTmpNo == "")
{
strTmpNo = "'" + uGridData.Rows[i].Cells["FS_WEIGHTNO"].Value.ToString() + "'";
}
else
{
strTmpNo += ",'" + uGridData.Rows[i].Cells["FS_WEIGHTNO"].Value.ToString() + "'";
}
if (strTmpLh == "")
{
strTmpLh = uGridData.Rows[i].Cells["FS_STOVENO"].Value.ToString();
}
else
{
strTmpLh += "," + uGridData.Rows[i].Cells["FS_STOVENO"].Value.ToString();
}
}
}
listSubItem.Add(dTmpZl.ToString()); //发货数量
listSubItem.Add("TON"); //收货时的计量单位
listSubItem.Add("0001"); //项目文本
listSubItem.Add(strTmpOrder); //生产订单编号
listSubItem.Add("F"); //移动标识'F'
listSubItem.Add(""); //销售订单号
listSubItem.Add(""); //销售订单行项目
listItem.Add(listSubItem);
ccp.ServerName = "Core.KgMcms.Sap.UploadSapRfc";
ccp.MethodName = "up_Product";
ccp.ServerParams = new object[] { strTmpRfc, strTmpHeader, strTmpCode, listItem };
this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
string sTmp;
if (ccp.ReturnCode == 0)
{
sTmp = ccp.ReturnObject.ToString();
strTmpUpload[2] = sTmp + "-" + strTmpLh;
strTmpUpload[6] = dTmpZl.ToString();
lstHint2.Items.Add(sTmp);
uptSapLog(strTmpNo, strTmpUpload);
showGridInfo();
sTmp += "，数据上传成功！";
}
else
{
sTmp = ccp.ReturnInfo;
}
lstHint2.Items.Add(sTmp);
}
