protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
Boolean modified = false;
foreach (DictionaryEntry val in e.OldValues)
{
if (e.NewValues[val.Key] == val.Value)
{
modified = true;
}
}
Int32 q = 0;
if (modified && Int32.TryParse(e.NewValues["Quantity"].ToString(), out q))
{
DataRow row = Data.Rows.Find(e.Keys["ID"]);
row["ProductID"] = e.NewValues["ProductID"];
row["Quantity"] = q;
row["Description"] = e.NewValues["Description"];
}
ASPxGridView1.CancelEdit();
e.Cancel = true;
ASPxGridView1.DataBind();
}
// 修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox pCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxTextBox;
ASPxTextBox pName = ASPxGridView1.FindEditFormTemplateControl("txtPName") as ASPxTextBox;
ASPxTextBox pNameEn = ASPxGridView1.FindEditFormTemplateControl("txtPNameEn") as ASPxTextBox;
ASPxTextBox pValue = ASPxGridView1.FindEditFormTemplateControl("txtPValue") as ASPxTextBox;
ASPxCheckBox chRFlag = ASPxGridView1.FindEditFormTemplateControl("chRFlag") as ASPxCheckBox;
string rFlag = "";
if (chRFlag.Checked == true)
{
rFlag = "Y";
}
else
{
rFlag = "N";
}
string upSql = "UPDATE CODE_PROGRAM SET PROGRAM_NAME='" + pName.Text.Trim() + "',PROGRAM_NAME_EN='" + pNameEn.Text.Trim() + "',PROGRAM_VALUE='" + pValue.Text.Trim() + "',"
+ "RIGHT_FLAG='" + rFlag + "' WHERE COMPANY_CODE = '" + theCompanyCode + "' AND PROGRAM_CODE='" + pCode.Text.Trim() + "'";
theDc.ExeSql(upSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
//新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox pLine = ASPxGridView1.FindEditFormTemplateControl("comboPLine") as ASPxComboBox;
ASPxComboBox zdmc = ASPxGridView1.FindEditFormTemplateControl("comboStationCode") as ASPxComboBox;
ASPxTextBox zddm = ASPxGridView1.FindEditFormTemplateControl("txtStationName") as ASPxTextBox;
ASPxGridLookup gridlookup = ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxGridLookup;
ASPxComboBox part_ABC = ASPxGridView1.FindEditFormTemplateControl("comboLJLB") as ASPxComboBox;
string ljdm = gridlookup.Value.ToString();
string ljmc = gridlookup.Text.Trim();
string Sql = "INSERT INTO ATPUZDLJMLB (GZDD,ZDDM,ZDMC,LJDM,LJMC,INPUT_PERSON,INPUT_TIME,PART_ABC) "
+ "VALUES( '" + pLine.Value.ToString() + "','" + zddm.Text.Trim() + "','" + zdmc.Value.ToString() + "','" + ljdm + "','" + ljmc + "','" + theUserId + "',SYSDATE,'" + part_ABC.Value.ToString() + "')";
dc.ExeSql(Sql);
//插入到日志表161103
try
{
string Sql2 = "INSERT INTO ATPUZDLJMLB_LOG (GZDD,ZDDM,ZDMC,LJDM,LJMC,user_code,flag,rqsj,PART_ABC)"
+ " SELECT GZDD,ZDDM,ZDMC,LJDM,LJMC,'" + theUserCode + "' , 'ADD', SYSDATE,PART_ABC FROM ATPUZDLJMLB WHERE GZDD = '" + pLine.Value.ToString() + "' and ZDMC = '" + zdmc.Value.ToString() + "' and LJDM = '" + ljdm + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uCode = ASPxGridView1.FindEditFormTemplateControl("txtStationCode") as ASPxTextBox;
ASPxTextBox uName = ASPxGridView1.FindEditFormTemplateControl("txtStationName") as ASPxTextBox;
ASPxComboBox uTcode = ASPxGridView1.FindEditFormTemplateControl("dropStaionType") as ASPxComboBox;
ASPxComboBox uPcode = ASPxGridView1.FindEditFormTemplateControl("dropPlineCode") as ASPxComboBox;
ASPxTextBox uScode = ASPxGridView1.FindEditFormTemplateControl("dropStaionArea") as ASPxTextBox;
StationEntity s = new StationEntity()
{
COMPANY_CODE = theCompanyCode,
PLINE_CODE = uPcode.Value.ToString(),
STATION_CODE = uCode.Text.Trim(),
STATION_NAME = uName.Text.Trim(),
STATION_TYPE_CODE = uTcode.Value as string,
STATION_AREA_CODE = uScode.Value as string,
WORKUNIT_CODE = e.NewValues["WORKUNIT_CODE"] as string
};
s.RMES_ID = s.STATION_CODE;
StationFactory.Insert(s);
//string Sql = "INSERT INTO CODE_STATION (COMPANY_CODE,STATION_CODE,STATION_NAME,STATION_TYPE_CODE,PLINE_CODE,STATION_AREA_CODE) "
// + "VALUES('" + theCompanyCode + "','" + uCode.Text.Trim() + "','" + uName.Text.Trim() + "','" + uTcode.Value.ToString() + "','" + uPcode.Value.ToString() + "','" + uScode.Value.ToString() + "')";
//dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uMCode = ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox;
ASPxTextBox uMName = ASPxGridView1.FindEditFormTemplateControl("txtMName") as ASPxTextBox;
ASPxTextBox uGCode = ASPxGridView1.FindEditFormTemplateControl("txtGCode") as ASPxTextBox;
ASPxTextBox uGName = ASPxGridView1.FindEditFormTemplateControl("txtGName") as ASPxTextBox;
ASPxComboBox uLocation = ASPxGridView1.FindEditFormTemplateControl("txtLocation") as ASPxComboBox;
ASPxComboBox uQSite = ASPxGridView1.FindEditFormTemplateControl("txtQSite") as ASPxComboBox;
ASPxTextBox uMNum = ASPxGridView1.FindEditFormTemplateControl("txtMNum") as ASPxTextBox;
ASPxDateEdit uOnTime = ASPxGridView1.FindEditFormTemplateControl("txtOnTime") as ASPxDateEdit;
string strPCode = uPCode.Value.ToString();
string strQSite = uQSite.Value.ToString();
string strMCode = uMCode.Text.Trim();
string strMName = uMName.Text.Trim();
string strGName = uGName.Text.Trim();
string strGCode = uGCode.Text.Trim();
string strMNum = uMNum.Text.Trim();
string locationCode = uLocation.Text.Trim();
string Sql = "insert into ms_single_mat_inner(material_code,material_num,online_time,online_location,add_time,flag,gzdd,gys_code,qadsite)"
+ "VALUES('" + strMCode + "','" + strMNum + "',to_date('" + uOnTime.Value + "','yyyy-mm-dd hh24:mi:ss'),'" + locationCode + "',"
+ "sysdate ,'N','" + strPCode + "','" + strGCode + "','" + strQSite + "')";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
string rmes_id = e.OldValues["RMES_ID"].ToString();
DetectErrorItemEntity detEntity = db.First <DetectErrorItemEntity>("where rmes_id=@0", rmes_id);
ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox;
ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("comWorkUnit") as ASPxComboBox;
ASPxComboBox detectData = ASPxGridView1.FindEditFormTemplateControl("comDetectItem") as ASPxComboBox;
detEntity.COMPANY_CODE = theCompanyCode;
detEntity.PLINE_CODE = pline.SelectedItem.Value.ToString();
detEntity.WORKUNIT_CODE = e.NewValues["WORKUNIT_CODE"].ToString();
detEntity.DETECT_ITEM_CODE = detectData.Value.ToString();
detEntity.DETECT_ITEM_NAME = detectData.Text.ToString();
detEntity.ERROR_ITEM_CODE = e.NewValues["ERROR_ITEM_CODE"].ToString();
detEntity.ERROR_ITEM_NAME = e.NewValues["ERROR_ITEM_NAME"].ToString();
db.Update(detEntity);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox zbct = ASPxGridView1.FindEditFormTemplateControl("zbct") as ASPxTextBox;
ASPxTextBox wcct = ASPxGridView1.FindEditFormTemplateControl("wcct") as ASPxTextBox;
ASPxTextBox snct = ASPxGridView1.FindEditFormTemplateControl("snct") as ASPxTextBox;
ASPxTextBox tqct = ASPxGridView1.FindEditFormTemplateControl("tqct") as ASPxTextBox;
ASPxTextBox zbyj = ASPxGridView1.FindEditFormTemplateControl("zbyj") as ASPxTextBox;
ASPxTextBox wcyj = ASPxGridView1.FindEditFormTemplateControl("wcyj") as ASPxTextBox;
ASPxTextBox snyj = ASPxGridView1.FindEditFormTemplateControl("snyj") as ASPxTextBox;
ASPxTextBox tqyj = ASPxGridView1.FindEditFormTemplateControl("tqyj") as ASPxTextBox;
ASPxTextBox zbck = ASPxGridView1.FindEditFormTemplateControl("zbck") as ASPxTextBox;
ASPxTextBox wcck = ASPxGridView1.FindEditFormTemplateControl("wcck") as ASPxTextBox;
ASPxTextBox snck = ASPxGridView1.FindEditFormTemplateControl("snck") as ASPxTextBox;
ASPxTextBox tqck = ASPxGridView1.FindEditFormTemplateControl("tqck") as ASPxTextBox;
ASPxTextBox pro = ASPxGridView1.FindEditFormTemplateControl("PRO") as ASPxTextBox;
string upSql = "UPDATE CODE_MON_TAR SET ZBCT='" + zbct.Text.Trim() + "',WCCT='" + wcct.Text.Trim() + "',SNCT='" + snct.Text.Trim() + "',TQCT='" + tqct.Text.Trim() + "'," +
"ZBYJ='" + zbyj.Text.Trim() + "',WCYJ='" + wcyj.Text.Trim() + "',SNYJ='" + snyj.Text.Trim() + "',TQYJ='" + tqyj.Text.Trim() + "'," +
"ZBCK='" + zbck.Text.Trim() + "',WCCK='" + wcck.Text.Trim() + "',SNCK='" + snck.Text.Trim() + "',TQCK='" + tqck.Text.Trim() +
"' WHERE PRO='" + pro.Text.Trim() + "'";
dc.ExeSql(upSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
SetCondition();
}
//修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uSName = ASPxGridView1.FindEditFormTemplateControl("txtSName") as ASPxTextBox;
ASPxTextBox uSinitial = ASPxGridView1.FindEditFormTemplateControl("txtSinitial") as ASPxTextBox;
ASPxTextBox uSmax = ASPxGridView1.FindEditFormTemplateControl("txtSmax") as ASPxTextBox;
ASPxTextBox uSwarning = ASPxGridView1.FindEditFormTemplateControl("txtSwarning") as ASPxTextBox;
ASPxComboBox uIflag = ASPxGridView1.FindEditFormTemplateControl("ASPxComboBox1") as ASPxComboBox;
ASPxComboBox uEflag = ASPxGridView1.FindEditFormTemplateControl("ASPxComboBox2") as ASPxComboBox;
string strPCode = uPCode.Value.ToString();
string strSinitial = uSinitial.Text.Trim();
string strSName = uSName.Text.Trim();
string strSmax = uSmax.Text.Trim();
string strSwarning = uSwarning.Text.Trim();
string strIflag = uIflag.Value.ToString();
string strEflag = uEflag.Value.ToString();
string strID = e.OldValues["RMES_ID"].ToString().Trim();
string Sql = "UPDATE CODE_SN SET PLINE_CODE='" + strPCode + "',INITIAL_VALUE='" + strSinitial + "',MAX_VALUE='" + strSmax + "',INCREASE_FLAG='" + strIflag + "',ENABLE_FLAG='" + strEflag + "',WARNING_VALUE='" + strSwarning + "',VENDER_CODE='" + strSName + "'"
+ " WHERE COMPANY_CODE = '" + theCompanyCode + "' and RMES_ID= '" + strID + "'";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
// 主表修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
//ASPxLabel billId = ASPxGridView1.FindEditFormTemplateControl("LabBillId") as ASPxLabel;
ASPxTextBox assetcode = ASPxGridView1.FindEditFormTemplateControl("txtAssetCode") as ASPxTextBox;
ASPxTextBox srlno = ASPxGridView1.FindEditFormTemplateControl("txtSrlNo") as ASPxTextBox;
ASPxGridLookup lkpVendor = ASPxGridView1.FindEditFormTemplateControl("GridLookupVendor") as ASPxGridLookup;
ASPxGridLookup lkpManuf = ASPxGridView1.FindEditFormTemplateControl("GridLookupManuf") as ASPxGridLookup;
ASPxGridLookup lkpDept = ASPxGridView1.FindEditFormTemplateControl("GridLookupDept") as ASPxGridLookup;
ASPxDateEdit dtePurchDate = ASPxGridView1.FindEditFormTemplateControl("CalPCDate") as ASPxDateEdit;
ASPxTextBox txtPurchCost = ASPxGridView1.FindEditFormTemplateControl("txtPrice") as ASPxTextBox;
ASPxDateEdit wrtStartDate = ASPxGridView1.FindEditFormTemplateControl("CalWRTStartDate") as ASPxDateEdit;
ASPxDateEdit wrtEndDate = ASPxGridView1.FindEditFormTemplateControl("CalWRTEndDate") as ASPxDateEdit;
ASPxTextBox txtAssetColor = ASPxGridView1.FindEditFormTemplateControl("txtColor") as ASPxTextBox;
ASPxTextBox txtBarCode = ASPxGridView1.FindEditFormTemplateControl("txtBarCode") as ASPxTextBox;
ASPxGridLookup lkpRspPerson = ASPxGridView1.FindEditFormTemplateControl("lkpResponsePerson") as ASPxGridLookup;
ASPxCheckBox chkActiveFlag = ASPxGridView1.FindEditFormTemplateControl("chkActiveFlag") as ASPxCheckBox;
ASPxMemo assetRemark = ASPxGridView1.FindEditFormTemplateControl("txtRemark") as ASPxMemo;
string deptCode = "", vendorCode = "", manufCode = "", rspPerson = "";
ASPxGridLookup gridLookupVendor = ASPxGridView1.FindEditFormTemplateControl("GridLookupVendor") as ASPxGridLookup;
ASPxTextBox txtSVendor = ASPxGridView1.FindEditFormTemplateControl("txtSVendor") as ASPxTextBox;
if (lkpDept.Value != null)
{
deptCode = lkpDept.Value.ToString();
}
if (lkpManuf.Value != null)
{
manufCode = lkpManuf.Value.ToString();
}
if (lkpVendor.Value != null)
{
vendorCode = lkpVendor.Value.ToString();
}
if (lkpRspPerson.Value != null)
{
rspPerson = lkpRspPerson.Value.ToString();
}
string activeflag = chkActiveFlag.Checked ? "Y":"N";
string upSql = "UPDATE data_asset_detail SET vendor_code='" + vendorCode + "',manufacturer_code='" + lkpManuf.Value + "'," +
"response_dept_code='" + deptCode + "',purchase_date=to_date('" + dtePurchDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),purchase_cost=" + txtPurchCost.Text + "," +
"warranty_start_date=to_date('" + wrtStartDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),warranty_end_date=to_date('" + wrtEndDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss')," +
"response_person_code='" + lkpRspPerson.Value.ToString() + "',asset_color='" + txtAssetColor.Text + "',asset_remark='" + assetRemark.Text + "',active_flag='" + activeflag + "' " +
" WHERE COMPANY_CODE = '" + theCompanyCode + "' AND serial_number='" + srlno.Text + "'";
theDc.ExeSql(upSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
//新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uSO = ASPxGridView1.FindEditFormTemplateControl("TextSO") as ASPxTextBox;
ASPxComboBox uDYXH = ASPxGridView1.FindEditFormTemplateControl("ComboDYXH") as ASPxComboBox;
ASPxComboBox uFJB = ASPxGridView1.FindEditFormTemplateControl("ComboFJB") as ASPxComboBox;
string strSO = uSO.Text.Trim();
string strDYXH = uDYXH.Value.ToString();
string strFJB = uFJB.Value.ToString();
string Sql = "INSERT INTO ATPUSOFJB(SO,DYXH,BZDY,FJB,INPUT_PERSON,INPUT_TIME) "
+ "VALUES( '" + strSO.ToUpper() + "','" + strDYXH + "','包装单元" + strDYXH + "','" + strFJB + "','" + theUserCode + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUSOFJB_LOG (SO,DYXH,BZDY,FJB,user_code,flag,rqsj)"
+ " SELECT SO,DYXH,BZDY,FJB,'" + theUserCode + "' , 'ADD', SYSDATE FROM ATPUSOFJB WHERE SO = '" + strSO.ToUpper() + "' and DYXH = '" + strDYXH + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox aCode = ASPxGridView1.FindEditFormTemplateControl("txtAlineCode") as ASPxTextBox;
ASPxTextBox aName = ASPxGridView1.FindEditFormTemplateControl("txtAlineName") as ASPxTextBox;
ASPxComboBox PlineId = ASPxGridView1.FindEditFormTemplateControl("ASPxComboBox1") as ASPxComboBox;
string plineCode = "";
string plineName = "";
string chSql = "select pline_code,pline_name from code_product_line where rmes_id='" + PlineId.Value.ToString() + "'";
dataConn dc1 = new dataConn(chSql);
DataTable dt1 = dc1.GetTable();
if (dt1.Rows.Count > 0)
{
plineCode = dt1.Rows[0]["pline_code"].ToString();
plineName = dt1.Rows[0]["pline_name"].ToString();
}
string inSql = "INSERT INTO ATPU_ACROSSLINE (COMPANY_CODE,ALINE_CODE,ALINE_NAME,PLINE_ID,PLINE_CODE,PLINE_NAME) "
+ "VALUES ('" + theCompanyCode + "','" + aCode.Text.Trim() + "','" + aName.Text.Trim() + "',"
+ "'" + PlineId.Value.ToString() + "','" + plineCode + "','" + plineName + "')";
theDc.ExeSql(inSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
//删除
protected void ASPxGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
//判断当前记录是否可以删除
string strPLCode = e.Values["PLINE_CODE"].ToString();
string strMCode = e.Values["MATERIAL_CODE"].ToString().ToUpper();
string strGCode = e.Values["GYS_CODE"].ToString().ToUpper();
//string chSql = "SELECT * FROM ATPUFR WHERE FR='" + strFR + "' AND SC='" + strSC + "' AND DO='" + strDO + "'";
//DataTable dt = dc.GetTable(chSql);
//int theRet = dt.Rows.Count;
//if (theRet == 0)
//{
// ASPxGridView1.JSProperties.Add("cpCallbackName", "Delete");
// ASPxGridView1.JSProperties.Add("cpCallbackRet", theRet);
// //theDataConn.CloseConn();
//}
//else
//{
//确认删除
string Sql = "delete from ms_inv_mat where material_code='" + strMCode + "' and gys_code='" + strGCode + "' and gzdd='" + strPLCode + "'";
dc.ExeSql(Sql);
//}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
ASPxGridView1.JSProperties.Add("cpCallbackName", "refresh");
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uSO = ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxTextBox;
ASPxTextBox uCOLOR = ASPxGridView1.FindEditFormTemplateControl("txtColor") as ASPxTextBox;
ASPxTextBox uPRO = ASPxGridView1.FindEditFormTemplateControl("textPro") as ASPxTextBox;
ASPxComboBox GridLookupCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
string code = GridLookupCode.Value.ToString();
string Sql = "INSERT INTO ATPUEPAINTPROCOLOR (SO,SITE,PROC,COLOR,input_person,input_time) "
+ "VALUES( '" + uSO.Text.Trim().ToUpper() + "', '" + code + "','" + uPRO.Text.Trim() + "','" + uCOLOR.Text.Trim() + "','" + theUserId + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUEPAINTPROCOLOR_LOG(SO,SITE,PROC,COLOR,USER_CODE,FLAG,RQSJ)"
+ "VALUES('" + uSO.Text.Trim().ToUpper() + "', '" + code + "','" + uPRO.Text.Trim() + "','" + uCOLOR.Text.Trim() + "','" + theUserCode + "','ADD',SYSDATE)";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void Deleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
try
{
int receptionDetailTemp = Convert.ToInt32(e.Keys["PICKING_DETAIL"]);
_result = _wscalled.DeleteDetailPicking(receptionDetailTemp, Session["connectionString"].ToString());
e.Cancel = true;
ASPxGridView1.CancelEdit();
var pResult = "";
var dsDetail = _wscalled.GetPickingDetailForPickingHeader((int)Session["Header_picking"], Session["connectionString"].ToString(), ref pResult);
if (pResult == "")
{
ASPxGridView1.DataSource = dsDetail;
ASPxGridView1.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
//pcConfirm.ShowOnPageLoad = false;
GetSku();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
//修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
if (txtPCode.Text.Trim() == "")
{
return;
}
else
{
ASPxTextBox uPSo = ASPxGridView1.FindEditFormTemplateControl("txtPSo") as ASPxTextBox;
//ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uPNum = ASPxGridView1.FindEditFormTemplateControl("txtPNum") as ASPxTextBox;
ASPxComboBox uPlanCode = ASPxGridView1.FindEditFormTemplateControl("txtPlanCode") as ASPxComboBox;
ASPxComboBox uOnLocation = ASPxGridView1.FindEditFormTemplateControl("txtOnLocation") as ASPxComboBox;
ASPxDateEdit uOnlinetime = ASPxGridView1.FindEditFormTemplateControl("DateOnlinetime") as ASPxDateEdit;
string strPSo = uPSo.Text.Trim();
string strPCode = txtPCode.Value.ToString();
string strPNum = uPNum.Text.Trim();
string strPlanCode = uPlanCode.Value.ToString();
string strOnLocation = uOnLocation.Value.ToString();
string strOnlinetime = uOnlinetime.Text.Trim();
string Sql = "update ms_single_plan set PLAN_NUM='" + strPNum + "',online_location='" + strOnLocation + "',online_time=to_date('" + uOnlinetime.Value + "','yyyy-mm-dd hh24:mi:ss')"
+ "where PLAN_CODE='" + strPlanCode + "' and FLAG='N' and gzdd='" + strPCode + "'";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
DataTable dt = Session["GridDataSource"] as DataTable;
//Modify row values after a single grid row has been edited
if (ASPxGridView1.Selection.Count == 1)
{
DataRow row = dt.Rows.Find(e.Keys["ID"]) as DataRow;
row["Song"] = e.NewValues["Song"];
row["Genre"] = e.NewValues["Genre"];
}
//Modify row values after multiple grid rows have been edited
if (ASPxGridView1.Selection.Count > 1)
{
//Obtain key field values of the selected rows
List <object> selectedRowKeys = ASPxGridView1.GetSelectedFieldValues("ID");
for (int i = 0; i < selectedRowKeys.Count; i++)
{
//Find a row in the data table by the row's key field value
DataRow row = dt.Rows.Find(selectedRowKeys[i]) as DataRow;
//Modify data rows by leaving old values (if the EditForm's editors are left blank) or saving new values entered into editors
row["Song"] = (e.NewValues["Song"] == null) ? row["Song"] : e.NewValues["Song"];
row["Genre"] = (e.NewValues["Genre"] == null) ? row["Genre"] : e.NewValues["Genre"];
continue;
}
}
dt.AcceptChanges();
Session["GridDataSource"] = dt;
//Close the grid's EditForm and avoid default update processing from being executed
e.Cancel = true;
ASPxGridView1.CancelEdit();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox yeartotal = ASPxGridView1.FindEditFormTemplateControl("yeartotal") as ASPxTextBox;
ASPxTextBox jan = ASPxGridView1.FindEditFormTemplateControl("jan") as ASPxTextBox;
ASPxTextBox feb = ASPxGridView1.FindEditFormTemplateControl("feb") as ASPxTextBox;
ASPxTextBox mar = ASPxGridView1.FindEditFormTemplateControl("mar") as ASPxTextBox;
ASPxTextBox total1 = ASPxGridView1.FindEditFormTemplateControl("total1") as ASPxTextBox;
ASPxTextBox apr = ASPxGridView1.FindEditFormTemplateControl("apr") as ASPxTextBox;
ASPxTextBox may = ASPxGridView1.FindEditFormTemplateControl("may") as ASPxTextBox;
ASPxTextBox june = ASPxGridView1.FindEditFormTemplateControl("june") as ASPxTextBox;
ASPxTextBox total2 = ASPxGridView1.FindEditFormTemplateControl("total2") as ASPxTextBox;
ASPxTextBox july = ASPxGridView1.FindEditFormTemplateControl("july") as ASPxTextBox;
ASPxTextBox aug = ASPxGridView1.FindEditFormTemplateControl("aug") as ASPxTextBox;
ASPxTextBox sep = ASPxGridView1.FindEditFormTemplateControl("sep") as ASPxTextBox;
ASPxTextBox total3 = ASPxGridView1.FindEditFormTemplateControl("total3") as ASPxTextBox;
ASPxTextBox oct = ASPxGridView1.FindEditFormTemplateControl("oct") as ASPxTextBox;
ASPxTextBox nov = ASPxGridView1.FindEditFormTemplateControl("nov") as ASPxTextBox;
ASPxTextBox dec = ASPxGridView1.FindEditFormTemplateControl("dec") as ASPxTextBox;
ASPxTextBox total4 = ASPxGridView1.FindEditFormTemplateControl("total4") as ASPxTextBox;
ASPxTextBox pro = ASPxGridView1.FindEditFormTemplateControl("PRO") as ASPxTextBox;
string upSql = "UPDATE CODE_YEAR_TAR SET YEAR_TOTAL='" + yeartotal.Text.Trim() + "',JAN='" + jan.Text.Trim() + "',FEB='" + feb.Text.Trim() + "',MAR='" + mar.Text.Trim() + "',TOTAL1='" + total1.Text.Trim() + "'," +
"APR='" + apr.Text.Trim() + "',MAY='" + may.Text.Trim() + "',JUNE='" + june.Text.Trim() + "',TOTAL2='" + total2.Text.Trim() + "'," +
"JULY='" + july.Text.Trim() + "',AUG='" + aug.Text.Trim() + "',SEP='" + sep.Text.Trim() + "',TOTAL3='" + total3.Text.Trim() + "'," +
"OCT='" + oct.Text.Trim() + "',NOV='" + nov.Text.Trim() + "',DEC='" + dec.Text.Trim() + "',TOTAL4='" + total4.Text.Trim() +
"' WHERE PRO='" + pro.Text.Trim() + "'";
dc.ExeSql(upSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
SetCondition();
}
//新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridLookup uSO = ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxGridLookup;
ASPxTextBox uJX = ASPxGridView1.FindEditFormTemplateControl("txtJX") as ASPxTextBox;
ASPxTextBox uPQBAK = ASPxGridView1.FindEditFormTemplateControl("txtPQBAK") as ASPxTextBox;
ASPxTextBox uREMARK = ASPxGridView1.FindEditFormTemplateControl("txtREMARK") as ASPxTextBox;
string strSO = uSO.Value.ToString();
string strJX = uJX.Text.Trim();
string strPQBAK = uPQBAK.Text.Trim();
string strREMARK = uREMARK.Text.Trim();
string Sql = "INSERT INTO PAINT_SO (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,input_person,input_time) "
+ "VALUES( '" + strSO + "','" + strPQBAK + "','" + strPQBAK + "','" + strREMARK + "','" + strJX + "','" + theUserId + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO PAINT_SO_LOG (SO,TYPE_PQ,TYPE_PQBAK,REMARK,JX,user_code,flag,rqsj)"
+ " VALUES( '" + strSO + "','" + strPQBAK + "','" + strPQBAK + "','" + strREMARK + "','" + strJX + "','" + theUserCode + "' , 'ADD', SYSDATE) ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox pline = ASPxGridView1.FindEditFormTemplateControl("combPline") as ASPxComboBox;
ASPxComboBox workUnit = ASPxGridView1.FindEditFormTemplateControl("comWorkUnit") as ASPxComboBox;
ASPxComboBox detectData = ASPxGridView1.FindEditFormTemplateControl("comDetectItem") as ASPxComboBox;
DetectErrorItemEntity detEntity = new DetectErrorItemEntity();
detEntity.COMPANY_CODE = theCompanyCode;
detEntity.DETECT_ITEM_CODE = detectData.Value.ToString();
detEntity.DETECT_ITEM_NAME = detectData.Text.ToString();
detEntity.ERROR_ITEM_CODE = e.NewValues["ERROR_ITEM_CODE"].ToString();
detEntity.ERROR_ITEM_NAME = e.NewValues["ERROR_ITEM_NAME"].ToString();
detEntity.PLINE_CODE = pline.SelectedItem.Value.ToString();
detEntity.WORKUNIT_CODE = e.NewValues["WORKUNIT_CODE"].ToString();
db.Insert(detEntity);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
//插入新纪录，应先做检查是否合法
FaultEntity fauEntity = new FaultEntity();
fauEntity.COMPANY_CODE = theCompanyCode;
fauEntity.FAULT_CODE = e.NewValues["FAULT_CODE"].ToString().Trim();
fauEntity.FAULT_NAME = e.NewValues["FAULT_NAME"].ToString().Trim();
fauEntity.FAULT_DESC = e.NewValues["FAULT_DESC"].ToString().Trim();
fauEntity.FAULT_CLASS = e.NewValues["FAULT_CLASS"].ToString().Trim();
fauEntity.FAULT_TYPE = e.NewValues["FAULT_TYPE"].ToString().Trim();
fauEntity.INPUT_TIME = DateTime.Now;
fauEntity.INPUT_PERSON = theUserId;
db.Insert(fauEntity);
//插入到日志表20161101
try
{
string Sql2 = "INSERT INTO CODE_FAULT_LOG (RMES_ID,COMPANY_CODE,FAULT_CODE,FAULT_NAME,FAULT_DESC,FAULT_CLASS,FAULT_TYPE,user_code,flag,rqsj)"
+ " SELECT RMES_ID,COMPANY_CODE,FAULT_CODE,FAULT_NAME,FAULT_DESC,FAULT_CLASS,FAULT_TYPE,'" + theUserCode + "' , 'ADD', SYSDATE FROM CODE_FAULT WHERE FAULT_CODE = '"
+ e.NewValues["FAULT_CODE"].ToString().Trim() + "' AND FAULT_NAME = '" + e.NewValues["FAULT_NAME"].ToString().Trim() + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox uCode = ASPxGridView1.FindEditFormTemplateControl("txtStationCode") as ASPxTextBox;
ASPxTextBox uName = ASPxGridView1.FindEditFormTemplateControl("txtStationName") as ASPxTextBox;
ASPxComboBox uTcode = ASPxGridView1.FindEditFormTemplateControl("dropStaionType") as ASPxComboBox;
ASPxComboBox uPcode = ASPxGridView1.FindEditFormTemplateControl("dropPlineCode") as ASPxComboBox;
ASPxTextBox uScode = ASPxGridView1.FindEditFormTemplateControl("dropStaionArea") as ASPxTextBox;
string id = e.NewValues["RMES_ID"] as string;
StationEntity s = new StationEntity()
{
RMES_ID = id,
COMPANY_CODE = theCompanyCode,
PLINE_CODE = uPcode.Value.ToString(),
STATION_CODE = uCode.Text.Trim(),
STATION_NAME = uName.Text.Trim(),
STATION_TYPE_CODE = uTcode.Value as string,
STATION_AREA_CODE = uScode.Value as string,
WORKUNIT_CODE = e.NewValues["WORKUNIT_CODE"] as string
};
db.Update("CODE_STATION", "RMES_ID", s);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
//新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox uRGzdd = ASPxGridView1.FindEditFormTemplateControl("txtRGzdd") as ASPxComboBox;
ASPxComboBox uRLocation = ASPxGridView1.FindEditFormTemplateControl("txtRLocation") as ASPxComboBox;
ASPxComboBox uIGzdd = ASPxGridView1.FindEditFormTemplateControl("txtIGzdd") as ASPxComboBox;
ASPxComboBox uILocation = ASPxGridView1.FindEditFormTemplateControl("txtILocation") as ASPxComboBox;
string strRGzdd = uRGzdd.Value.ToString();
string strRLocation = uRLocation.Value.ToString();
string strIGzdd = uIGzdd.Value.ToString();
string strILocation = uILocation.Value.ToString();
strRGzdd = strRGzdd.Substring(0, 1);
string Sql = "INSERT INTO MS_ISSUE_LOCATION (REAL_GZDD,REAL_LOCATION,ISSUE_GZDD,ISSUE_LOCATION,input_person,input_time)VALUES('" + strRGzdd + "','" + strRLocation + "','" + strIGzdd + "','" + strILocation + "','" + theUserId + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO MS_ISSUE_LOCATION_LOG (REAL_GZDD,REAL_LOCATION,ISSUE_GZDD,ISSUE_LOCATION,user_code,flag,rqsj)"
+ " SELECT REAL_GZDD,REAL_LOCATION,ISSUE_GZDD,ISSUE_LOCATION,'"
+ theUserCode + "' , 'ADD', SYSDATE FROM MS_ISSUE_LOCATION WHERE real_gzdd='"
+ strRGzdd + "' and real_location='" + strRLocation + "' and issue_gzdd='" + strIGzdd + "' and issue_location='" + strILocation + "' ";
dc.ExeSql(Sql2);
}
catch
{
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uKHMC = ASPxGridView1.FindEditFormTemplateControl("txtKHMC") as ASPxTextBox;
ASPxTextBox uKHH = ASPxGridView1.FindEditFormTemplateControl("txtKHH") as ASPxTextBox;
ASPxTextBox uWLH = ASPxGridView1.FindEditFormTemplateControl("txtWLH") as ASPxTextBox;
ASPxTextBox uGYSDM = ASPxGridView1.FindEditFormTemplateControl("txtGYSDM") as ASPxTextBox;
ASPxTextBox uSO = ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxTextBox;
ASPxTextBox uBBH = ASPxGridView1.FindEditFormTemplateControl("txtBBH") as ASPxTextBox;
string Sql = "INSERT INTO ATPUKHTM (KHMC,KHH,WLH,GYSDM,SO,BBH,INPUT_PERSON,INPUT_TIME) "
+ "VALUES( '" + uKHMC.Text.Trim() + "', '" + uKHH.Text.Trim() + "','" + uWLH.Text.Trim() + "','" + uGYSDM.Text.Trim() + "','" + uSO.Text.Trim() + "','" + uBBH.Text.Trim() + "','" + theUserId + "',sysdate)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUKHTM_LOG (khmc,khh,wlh,gysdm,sn,so,bbh,user_code,flag,rqsj)"
+ " SELECT khmc,khh,wlh,gysdm,sn,so,bbh,'" + theUserCode + "' , 'ADD', SYSDATE FROM ATPUKHTM WHERE SO = '" + uSO.Text.Trim() + "' AND KHMC = '" + uKHMC.Text.Trim() + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
//修改记录
//string strCode = e.OldValues["PLAN_CODE"].ToString();
//string newCode = e.NewValues["PLAN_CODE"].ToString();
string rmes_id = e.OldValues["RMES_ID"].ToString();
ASPxComboBox plineCode = ASPxGridView1.FindEditFormTemplateControl("plineCode") as ASPxComboBox;
ASPxComboBox productSeries = ASPxGridView1.FindEditFormTemplateControl("productSeries") as ASPxComboBox;
QualityItemEntity quaEntity = new QualityItemEntity();
quaEntity.RMES_ID = rmes_id;
quaEntity.COMPANY_CODE = theCompanyCode;
quaEntity.PLINE_CODE = plineCode.SelectedItem.Value.ToString().Trim();
quaEntity.SERIES_CODE = productSeries.SelectedItem.Value.ToString().Trim();
quaEntity.QUALITY_ITEM_CODE = e.NewValues["QUALITY_ITEM_CODE"].ToString().Trim();
quaEntity.QUALITY_ITEM_NAME = e.NewValues["QUALITY_ITEM_NAME"].ToString().Trim();
quaEntity.QUALITY_ITEM_DESC = e.NewValues["QUALITY_ITEM_DESC"].ToString().Trim();
db.Update(quaEntity);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
//修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uMCode = ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox;
ASPxTextBox uMName = ASPxGridView1.FindEditFormTemplateControl("txtMName") as ASPxTextBox;
ASPxTextBox uGCode = ASPxGridView1.FindEditFormTemplateControl("txtGCode") as ASPxTextBox;
ASPxTextBox uGName = ASPxGridView1.FindEditFormTemplateControl("txtGName") as ASPxTextBox;
ASPxComboBox uQSite = ASPxGridView1.FindEditFormTemplateControl("txtQSite") as ASPxComboBox;
ASPxTextBox uMNum = ASPxGridView1.FindEditFormTemplateControl("txtMNum") as ASPxTextBox;
ASPxDateEdit uOnTime = ASPxGridView1.FindEditFormTemplateControl("txtOnTime") as ASPxDateEdit;
ASPxComboBox uLocation = ASPxGridView1.FindEditFormTemplateControl("txtLocation") as ASPxComboBox;
string strPCode = uPCode.Value.ToString();
string strQSite = uQSite.Value.ToString();
string strMCode = uMCode.Text.Trim();
string strMName = uMName.Text.Trim();
string strGName = uGName.Text.Trim();
string strGCode = uGCode.Text.Trim();
string strMNum = uMNum.Text.Trim();
string locationCode = uLocation.Text.Trim();
string Sql = "update ms_single_mat_inner set material_num='" + strMNum + "',online_time=to_date('" + uOnTime.Value + "','yyyy-mm-dd hh24:mi:ss') "
+ " where material_code='" + strMCode + "' and gzdd='" + strPCode + "' and gys_code='" + strGCode + "' and online_location='" + locationCode + "' and qadsite='" + strQSite + "' and flag='N'";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
//插入新纪录，应先做检查是否合法
//设置初始值示例
//PlanEntity entPlan = new PlanEntity()
//{
// PLAN_CODE = "",
// PLAN_SO = ""
//};
//entPlan.PLAN_CODE = e.NewValues["PLAN_CODE"].ToString();
//entPlan.PLAN_MODELCODE = e.NewValues["PLAN_MODELCODE"].ToString().Trim();
//entPlan.PLAN_SO = e.NewValues["PLAN_SO"].ToString().Trim();
//entPlan.PLAN_MODIFYDATE = DateTime.Parse(e.NewValues["PLAN_MODIFYDATE"].ToString());
ASPxComboBox plineCode = ASPxGridView1.FindEditFormTemplateControl("plineCode") as ASPxComboBox;
ASPxComboBox productSeries = ASPxGridView1.FindEditFormTemplateControl("productSeries") as ASPxComboBox;
QualityItemEntity quaEntity = new QualityItemEntity();
quaEntity.COMPANY_CODE = theCompanyCode;
quaEntity.PLINE_CODE = plineCode.SelectedItem.Value.ToString().Trim();
quaEntity.SERIES_CODE = productSeries.SelectedItem.Value.ToString().Trim();
quaEntity.QUALITY_ITEM_CODE = e.NewValues["QUALITY_ITEM_CODE"].ToString().Trim();
quaEntity.QUALITY_ITEM_NAME = e.NewValues["QUALITY_ITEM_NAME"].ToString().Trim();
quaEntity.QUALITY_ITEM_DESC = e.NewValues["QUALITY_ITEM_DESC"].ToString().Trim();
db.Insert(quaEntity);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
// 新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox pCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxTextBox;
ASPxTextBox pName = ASPxGridView1.FindEditFormTemplateControl("txtPName") as ASPxTextBox;
ASPxTextBox pNameEn = ASPxGridView1.FindEditFormTemplateControl("txtPNameEn") as ASPxTextBox;
ASPxTextBox pValue = ASPxGridView1.FindEditFormTemplateControl("txtPValue") as ASPxTextBox;
ASPxCheckBox chRFlag = ASPxGridView1.FindEditFormTemplateControl("chRFlag") as ASPxCheckBox;
//string sql = "select 'PROG'||TRIM(TO_CHAR(SEQ_USER_ID.NEXTVAL,'000000')) from dual";
//theDc.setTheSql(sql);
//string dece_code1 = theDc.GetValue();
string dece_code1 = pCode.Text.Trim();
string rFlag = "";
if (chRFlag.Checked == true)
{
rFlag = "Y";
}
else
{
rFlag = "N";
}
string inSql = "INSERT INTO CODE_PROGRAM (COMPANY_CODE, PROGRAM_CODE, PROGRAM_NAME, PROGRAM_NAME_EN, PROGRAM_VALUE, RIGHT_FLAG) "
+ "VALUES('" + theCompanyCode + "','" + dece_code1 + "','" + pName.Text.Trim() + "','" + pNameEn.Text.Trim() + "','" + pValue.Text.Trim() + "','" + rFlag + "')";
dataConn inDc = new dataConn();
inDc.ExeSql(inSql);
inDc.CloseConn();
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
if (txtPCode.Text.Trim() == "")
{
return;
}
else
{
ASPxTextBox uPSo = ASPxGridView1.FindEditFormTemplateControl("txtPSo") as ASPxTextBox;
//ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uPNum = ASPxGridView1.FindEditFormTemplateControl("txtPNum") as ASPxTextBox;
ASPxComboBox uPlanCode = ASPxGridView1.FindEditFormTemplateControl("txtPlanCode") as ASPxComboBox;
ASPxComboBox uOnLocation = ASPxGridView1.FindEditFormTemplateControl("txtOnLocation") as ASPxComboBox;
ASPxDateEdit uOnlinetime = ASPxGridView1.FindEditFormTemplateControl("DateOnlinetime") as ASPxDateEdit;
string strPSo = uPSo.Text.Trim();
string strPCode = txtPCode.Value.ToString();
string strPNum = uPNum.Text.Trim();
string strPlanCode = uPlanCode.Value.ToString();
string strOnLocation = uOnLocation.Value.ToString();
string strOnlinetime = uOnlinetime.Text.Trim();
string Sql = "INSERT INTO MS_SINGLE_PLAN(PLAN_CODE,PLAN_SO,PLAN_NUM,ONLINE_LOCATION,ONLINE_TIME,FLAG,ADD_TIME,GZDD)"
+ "VALUES('" + strPlanCode + "','" + strPSo + "','" + strPNum + "','" + strOnLocation + "',to_date('" + uOnlinetime.Value + "','yyyy-mm-dd hh24:mi:ss'),'N',sysdate,'" + strPCode + "')";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
string rmes_id = e.OldValues["RMES_ID"].ToString();
ASPxComboBox plineCode = ASPxGridView1.FindEditFormTemplateControl("plineCode") as ASPxComboBox;
ASPxComboBox productSeries = ASPxGridView1.FindEditFormTemplateControl("productSeries") as ASPxComboBox;
ASPxComboBox detectDataType = ASPxGridView1.FindEditFormTemplateControl("detectDataType") as ASPxComboBox;
DetectDataEntity detEntity = new DetectDataEntity();
detEntity.RMES_ID = rmes_id;
detEntity.COMPANY_CODE = theCompanyCode;
detEntity.PLINE_CODE = plineCode.SelectedItem.Value.ToString().Trim();
detEntity.PRODUCT_SERIES = productSeries.SelectedItem.Value.ToString().Trim();
detEntity.DETECT_ITEM_CODE = e.NewValues["DETECT_ITEM_CODE"].ToString().Trim();
detEntity.DETECT_ITEM_NAME = e.NewValues["DETECT_ITEM_NAME"].ToString().Trim();
detEntity.DETECT_ITEM_CODE = e.NewValues["DETECT_DATA_CODE"].ToString().Trim();
detEntity.DETECT_ITEM_NAME = e.NewValues["DETECT_DATA_NAME"].ToString().Trim();
detEntity.DETECT_DATA_TYPE = detectDataType.SelectedItem.Value.ToString().Trim();
detEntity.DETECT_DATA_UNIT = e.NewValues["DETECT_DATA_UNIT"].ToString().Trim();
if (e.NewValues["STANDARD_VALUE"] == null || e.NewValues["STANDARD_VALUE"].ToString().Trim() == "")
{
detEntity.STANDARD_VALUE = 0;
}
else
{
detEntity.STANDARD_VALUE = int.Parse(e.NewValues["STANDARD_VALUE"].ToString().Trim());
detEntity.STANDARD_VALUE = int.Parse(e.NewValues["DETECT_DATA_STANDARD"].ToString().Trim());
}
if (e.NewValues["MAX_VALUE"] == null || e.NewValues["MAX_VALUE"].ToString().Trim() == "")
{
detEntity.MAX_VALUE = 0;
}
else
{
detEntity.MAX_VALUE = int.Parse(e.NewValues["MAX_VALUE"].ToString().Trim());
detEntity.MAX_VALUE = int.Parse(e.NewValues["DETECT_DATA_UP"].ToString().Trim());
}
if (e.NewValues["MIN_VALUE"] == null || e.NewValues["MIN_VALUE"].ToString().Trim() == "")
{
detEntity.MIN_VALUE = 0;
}
else
{
detEntity.MIN_VALUE = int.Parse(e.NewValues["MIN_VALUE"].ToString().Trim());
detEntity.MIN_VALUE = int.Parse(e.NewValues["DETECT_DATA_DOWN"].ToString().Trim());
}
db.Update(detEntity);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
//新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox ljdm = ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxComboBox;
ASPxDateEdit begindate1 = ASPxGridView1.FindEditFormTemplateControl("dateStart") as ASPxDateEdit;
ASPxDateEdit enddate1 = ASPxGridView1.FindEditFormTemplateControl("dateEnd") as ASPxDateEdit;
string ljmc = "";
string sqlC = "select PT_DESC2 from COPY_PT_MSTR where pt_part='" + ljdm.Value.ToString() + "'";
DataTable dt = dc.GetTable(sqlC);
if (dt.Rows.Count > 0)
{
ljmc = dt.Rows[0]["PT_DESC2"].ToString();
}
string Sql = "INSERT INTO ATPUBOMKZB (ABOM_COMP,ZDRQ,RQBEGIN,RQEND,LJMC) "
+ " VALUES ( '" + ljdm.Value.ToString() + "',sysdate,to_date('" + begindate1.Text.Trim() + "','yyyy-MM-dd'),to_date('" + enddate1.Text.Trim() + "','yyyy-MM-dd'),'" + ljmc + "')";
dc.ExeSql(Sql);
//记录操作start
string logSql = "insert into atpubomkzb_log(abom_comp,zdrq,rqbegin,rqend,rqsj,yhmc,czms)"
+ " select abom_comp,zdrq,rqbegin,rqend,sysdate,'" + theUserName + "','增加了新的零件' "
+ " from atpubomkzb where abom_comp='" + ljdm.Value.ToString() + "'";
dc.ExeSql(logSql);
//记录操作end
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition1();
}
