public void GetSapData(string erpDoc, string tipo)
{
var pResult = "";
var ds = new DataSet();
switch (tipo)
{
case "SO":
ds = _wscalled.GetSapPicking(Session["connectionString"].ToString(), erpDoc, ref pResult);
break;
case "IT":
ds = _wscalled.GetSapPickingItr(Session["connectionString"].ToString(), erpDoc, ref pResult);
break;
}
if (pResult == "")
{
Session["SAP_PICKING_DATA"] = ds;
ASPxGridView2.DataSource = ds;
ASPxGridView2.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
protected void ASPxButton3_Click(object sender, EventArgs e)
{
try
{
var fieldValues2 = ASPxGridView2.GetSelectedFieldValues(new[] { "TASK_ID" });
foreach (var t in fieldValues2)
{
_objTask.DeleteTask(Session["connectionString"].ToString(), t.ToString());
}
var fieldValues3 = ASPxGridView2.GetSelectedFieldValues(new[] { "TASK_ID", "OPERADOR" });
foreach (object[] value in fieldValues3)
{
ScriptManager.RegisterStartupScript(this, GetType(), "FuncionNJS", "ConnectNJS('" + value[1].ToString().ToUpper() + "' , 'CANCEL_TASK')", true);
}
var pResult = "";
var ds = _objTask.GetAllTaskStatus(Session["connectionString"].ToString(), ASPxDateEdit4.Date, ASPxDateEdit3.Date, ref pResult);
if (pResult == "")
{
Session["DATA_TASK2"] = ds;
ASPxGridView2.DataSource = ds;
ASPxGridView2.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
e.NewValues["RowStatus"] = Constant.ROWSTATUS_ACTIVE;
if (e.NewValues["IsDefault"] == null)
{
e.NewValues["IsDefault"] = false;
}
if (Util.isExistXpoObject <AccountingPeriodType>("Name", (string)e.NewValues["Name"]))
{
e.Cancel = true;
throw(new Exception("Trùng tên thể loại chu kì"));
}
if ((bool)e.NewValues["IsDefault"] == true)
{
CriteriaOperator criteria = new BinaryOperator("IsDefault", true, BinaryOperatorType.Equal);
AccountingPeriodType type = session.FindObject <AccountingPeriodType>(criteria);
e.NewValues["RowStatus"] = Constant.ROWSTATUS_ACTIVE;
if (type != null)
{
if (AccountingPeriodTypeBO.IsUsedAccoutingPeriodType(session, type.AccountingPeriodTypeId))
{
ASPxGridView2.CancelEdit();
throw new Exception("Loại chu kì nhỏ nhất " + type.Name + " đang được sử dụng nên không thể thay đổi");
}
type.IsDefault = false;
type.Save();
}
}
}
private void setCondition()
{
string sql = "";
sql = "select * from MS_JIT_LOG WHERE JITTIME>=to_date('" + ASPxDateEdit1.Text.Trim() + "','YYYY-MM-DD hh24:mi:ss') AND JITTIME<=to_date('" + ASPxDateEdit3.Text.Trim() + "','YYYY-MM-DD hh24:mi:ss') ";
if (ComboTabN.Text.Trim() == "三方物流要料")
{
sql = sql + " and JITFLAG='SF' ";
}
else
{
sql = sql + " and JITFLAG='KF' ";
}
sql = sql + " order by JITTIME desc";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
string sql2 = "SELECT NVL(JITUSER,'SYSTEM') JITUSER,DECODE(MANUALFLAG,'0','还未计算','1','已经计算') MANUALFLAG,TO_CHAR(COMMITTIME,'YYYY-MM-DD HH24:MI:SS') COMMITTIME,NVL(TO_CHAR(ONLINETIME,'YYYY-MM-DD HH24:MI:SS'),'') ONLINETIME,NVL(TO_CHAR(JITTIME,'YYYY-MM-DD HH24:MI:SS'),'') JITTIME FROM MS_JIT_MANUALFLAG WHERE "
+ "GZDD IN ( select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') and jitflag='SF' and committime>sysdate-3 order by committime";
DataTable dt2 = dc.GetTable(sql2);
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
}
private void setCondition()
{
string sql = "select * from sjbomsothxc where 1=1 ";
if (txtDH.Text.Trim() != "")
{
sql = sql + "and THGROUP='" + txtDH.Value.ToString() + "'";
}
if (txtJHDM.Text.Trim() != "")
{
sql = sql + "and JHDM='" + txtJHDM.Value.ToString() + "'";
}
sql = sql + " order by rqsj desc";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
sql = "select * from RST_ATPU_ZJTS_LOG where 1=1 ";
if (txtJHDM.Text.Trim() != "")
{
sql = sql + "and JHDM='" + txtJHDM.Value.ToString() + "'";
}
sql = sql + " order by rqsj desc";
DataTable dt1 = dc.GetTable(sql);
ASPxGridView2.DataSource = dt1;
ASPxGridView2.DataBind();
}
private void Query()
{
string sql = "SELECT PART,PART_DESC,DECODE(PART_TYPE,'1','非QAD零件','0','QAD零件') PART_TYPE,EDIT_NAME,EDIT_DATE,DEL_DATE,BGY,GZDD FROM ATPUBKFLPART_LOG WHERE ";
if (txtPlineCode.Text.Trim() == "")
{
sql = sql + " GZDD IN (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')";
}
else
{
sql = sql + " GZDD='" + txtPlineCode.Value.ToString() + "'";
}
if (ASPxDateEdit1.Text.Trim() != "")
{
sql = sql + " AND DEL_DATE>=to_date('" + ASPxDateEdit1.Text.Trim() + "','YYYY-MM-DD hh24:mi:ss') ";
}
if (ASPxDateEdit3.Text.Trim() != "")
{
sql = sql + " AND DEL_DATE<=to_date('" + ASPxDateEdit3.Text.Trim() + "','YYYY-MM-DD hh24:mi:ss') ";
}
if (TextPart.Text.Trim() != "")
{
sql = sql + " AND PART LIKE '%" + TextPart.Text.Trim() + "%'";
}
sql = sql + " ORDER BY PART";
DataTable dt = dc.GetTable(sql);
ASPxGridView2.DataSource = dt;
ASPxGridView2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Cookies["user"] == null)
{
Response.Redirect("~/Default.aspx");
}
else
{
if (!new UserSecurity().CheckFormPermission((int)Global.formSecurity.ViewProduct, Request.Cookies["user"]["Permission"].ToString()))
{
Response.Redirect("~/Finance_Module/UnAuthorized.aspx");
}
}
if (Convert.ToInt32(Request.QueryString["ID"].ToString()) > 0)
{
Product product = new Product();
product.get(Convert.ToInt32(Request.QueryString["ID"].ToString()));
lblProductID.Text = product.ID.ToString();
lblProductName.Text = product.Name.ToString();
lblCreationDate.Text = product.CreationDate.ToShortDateString();
lblLastModifiedDate.Text = product.LastModifiedDate.ToShortDateString();
lblType.Text = product.TypeID.ToString();
lblCost.Text = product.Cost.ToString();
lblPrice.Text = product.Price.ToString();
ProductPriceItems PPI = new ProductPriceItems();
ASPxGridView2.DataSource = PPI.getByProductID(Convert.ToInt32(Request.QueryString["ID"].ToString()));
ASPxGridView2.DataBind();
DataTable dt = product.getProductCustomers(Convert.ToInt32(Request.QueryString["ID"].ToString()));
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
}
}
protected void ASPxMenu2_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e)
{
if (ValidarConexionYUsuarioLogueado(new object()))
{
return;
}
try
{
var fieldValues = ASPxGridView2.GetSelectedFieldValues(new[] { "CODE_SKU" });
foreach (var t in fieldValues)
{
_objSeller.InsertSellerBySku(Session["connectionString"].ToString(), t.ToString(), Session["SELLER_CODE_BY_SKU"].ToString(), Session["USER"].ToString());
}
for (var i = 0; i < ASPxGridView2.VisibleRowCount; i++)
{
if (!ASPxGridView2.Selection.IsRowSelected(i))
{
var fieldValues2 = ASPxGridView2.GetRowValues(i, new[] { "CODE_SKU" });
_objSeller.DeleteSellerBySku(Session["connectionString"].ToString(), fieldValues2.ToString(), Session["SELLER_CODE_BY_SKU"].ToString());
//fieldValues2.ToString();
}
}
GetSellerBySku();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
public void GetSku(string codeSeller)
{
try
{
var pResult = "";
var ds = _objSeller.GetSkuSellerBySku(Session["connectionString"].ToString(), codeSeller, ref pResult);
//ds = objSKU.getSKU(Session["connectionString"].ToString());
if (pResult == "")
{
Session["DS_SKU_SELLER_BY_SKU"] = ds;
ASPxGridView2.DataSource = ds;
ASPxGridView2.DataBind();
for (var i = 0; ds.Tables[0].Rows.Count > i; i++)
{
if (ds.Tables[0].Rows[i]["VALOR"].ToString() == "1")
{
ASPxGridView2.Selection.SetSelection(i, true);
}
else
{
ASPxGridView2.Selection.SetSelection(i, false);
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
private void SetCondition()
{
string Chsql2 = "SELECT PLAN_SO,PLINE_CODE FROM DATA_PLAN WHERE PLAN_CODE='" + ASPxTextPlanCode.Text.Trim() + "'";
DataTable Chdt2 = dc.GetTable(Chsql2);
if (Chdt2.Rows.Count <= 0)
{
}
else
{
string Chsql3 = "SELECT STATION_CODE FROM CODE_STATION WHERE STATION_NAME='" + ASPxTextSation.Text.ToUpper().Trim() + "'";
DataTable Chdt3 = dc.GetTable(Chsql3);
if (Chdt3.Rows.Count <= 0)
{
}
}
string sql2 = "SELECT JHDM,PART,GXDM,CZTS,WJPATH,TSTYPE FROM RST_ATPU_ZJTS where JHDM='" + ASPxTextPlanCode.Text.Trim() + "' AND GXDM IN (select a.process_code from rel_location_process a ,"
+ "rel_station_location b,code_station c where c.station_code=b.station_code and b.location_code=a.location_code and c.station_name='" + ASPxTextSation.Text.ToUpper().Trim() + "')";
DataTable dt2 = dc.GetTable(sql2);
//Session["inv9501sql"] = sql2;
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
}
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox uGxdm = ASPxGridView2.FindEditFormTemplateControl("txtGxdm") as ASPxComboBox;
ASPxTextBox uPath = ASPxGridView2.FindEditFormTemplateControl("txtPath") as ASPxTextBox;
ASPxTextBox uCzts = ASPxGridView2.FindEditFormTemplateControl("txtCzts") as ASPxTextBox;
string gxdm = uGxdm.Text.Trim();
string path = uPath.Text.Trim();
string czts = uCzts.Text.Trim();
string part = ASPxGridView2.GetRowValues(ASPxGridView2.EditingRowVisibleIndex, new string[] { "PART" }).ToString();
//string part = e.NewValues["PART"].ToString();
//修改前数据插入到日志表
string Lsql = "insert into RST_ATPU_ZJTS_LOG(PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT,EDIT_USER,EDIT_FLAG,EDIT_DATE)select PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT, "
+ "'" + theUserName + "','BEFOREDIT',SYSDATE FROM RST_ATPU_ZJTS WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "' ";
dc.ExeSql(Lsql);
string Sql = "UPDATE RST_ATPU_ZJTS SET CZTS='" + czts + "', WJPATH='" + path + "'"
+ " WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "' ";
dc.ExeSql(Sql);
//修改后数据插入到日志表
string Lsql2 = "insert into RST_ATPU_ZJTS_LOG(PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT,EDIT_USER,EDIT_FLAG,EDIT_DATE)select PART,CZTS,GXDM,GZDD,JHDM,JHSO,TSTYPE,RQSJ,WJPATH,NOTE_COLOR,NOTE_FONT, "
+ "'" + theUserName + "','AFTEREDIT',SYSDATE FROM RST_ATPU_ZJTS WHERE GXDM = '" + gxdm + "' AND jhdm='" + ASPxTextPlanCode.Text.Trim() + "' AND PART='" + part + "'";
dc.ExeSql(Lsql2);
e.Cancel = true;
ASPxGridView2.CancelEdit();
//if (Session["inv9501sql"] as string != "")
//{
// DataTable dt2 = dc.GetTable(Session["inv9501sql"] as string);
// ASPxGridView2.DataSource = dt2;
// ASPxGridView2.DataBind();
//}
SetCondition();
}
private void setCondition()
{
DateTime DT1 = Convert.ToDateTime(ASPxDateEdit1.Text.Trim());
DateTime DT2 = Convert.ToDateTime(ASPxDateEdit2.Text.Trim());
if (DT1.AddDays(31) < DT2 || ASPxListBoxUsed.Items.Count <= 0 || txtPCode.Text.Trim() == "")
{
ASPxGridView2.DataSource = null;
ASPxGridView2.DataBind();
return;
}
string QtySql = "", part = "";
//QtySql = "select c.sn ,a.udesc,replace (a.comp,'#','') comp, sum(b.plan_qty*a.qty) sl from RSTBOMQD_ITEM8 a left join data_plan b "
//+"on a.plan_code=b.plan_code left join data_plan_sn c on a.plan_code=c.plan_code where udesc='&*北自所信息部' ";
QtySql = "select a.udesc,replace (a.comp,'#','') comp, sum(b.plan_qty*a.qty) sl from RSTBOMQD_ITEM8 a left join data_plan b on a.plan_code=b.plan_code where machinename='" + MachineName + "' and (udesc='&*北自所信息部' ";
for (int a = 0; a < ASPxListBoxUsed.Items.Count; a++)
{
QtySql = QtySql + "or ";
part = ASPxListBoxUsed.Items[a].ToString();
QtySql = QtySql + " a.udesc='" + part + "' ";
}
QtySql = QtySql + " ) group by a.comp,a.udesc order by a.udesc,a.comp ";
DataTable QtyDt = dc.GetTable(QtySql);
ASPxGridView2.DataSource = QtyDt;
ASPxGridView2.DataBind();
}
private void setCondition2()
{
string selSql2 = "select material_code,gys_code,cur_handle_num,to_char(CUR_HANDLE_TIME,'yyyy-mm-dd hh24:mi:ss') CUR_HANDLE_TIME,bill_code "
+ "from ms_inv_mat_log "
+ "where gzdd='" + comPLQ.Value.ToString() + "'";
if (txtMatCodeLog.Text != "")
{
selSql2 = selSql2 + " and material_code like UPPER('%" + txtMatCodeLog.Text.Trim() + "%') ";
}
if (txtGysCodeLog.Text != "")
{
selSql2 = selSql2 + " and gys_code like UPPER('%" + txtGysCodeLog.Text.Trim() + "%') ";
}
if (txtBillCodeQ.Text != "")
{
selSql2 = selSql2 + " and bill_code like UPPER('%" + txtBillCodeQ.Text.Trim() + "%') ";
}
if (StartDateQ.Value != null)
{
selSql2 = selSql2 + " and CUR_HANDLE_TIME >= to_date('" + StartDateQ.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss') ";
}
if (EndDateQ.Value != null)
{
selSql2 = selSql2 + " and CUR_HANDLE_TIME <= to_date('" + EndDateQ.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss') ";
}
selSql2 = selSql2 + " order by 1,2";
DataTable dt2 = dc.GetTable(selSql2);
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
}
private void setCondition()
{
string plancode = ASPxTextPlanCode.Text.Trim().ToUpper();
//if (plancode != "")
//{
// string sql = "select t.*,t.rowid from ms_over_mat_log t where 1=1 ";
// if (plancode != "")
// {
// sql = sql + " and bill_code='DEL-" + plancode + "' ";
// }
// sql = sql + ""; //order by MATERIAL_CODE
// DataTable dt = dc.GetTable(sql);
// ASPxGridView1.DataSource = dt;
// ASPxGridView1.DataBind();
//}
//else
//{
// string sql = "select t.*,t.rowid from ms_over_mat_log t where 1=2 ";
// sql = sql + ""; //order by MATERIAL_CODE
// DataTable dt = dc.GetTable(sql);
// ASPxGridView1.DataSource = dt;
// ASPxGridView1.DataBind();
//}
string sql1 = "select t.*,t.rowid from ms_plan_adjust_log t where 1=1 ";
sql1 = sql1 + " and gzdd in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + programcode + "' and company_code='" + theCompanyCode + "' )";
sql1 = sql1 + " order by log_time desc ";
DataTable dt1 = dc.GetTable(sql1);
ASPxGridView2.DataSource = dt1;
ASPxGridView2.DataBind();
}
private void setCondition()
{
//初始化GRIDVIEW
string sql = "SELECT A.RMES_ID,A.COMPANY_CODE,A.PLINE_CODE,D.PLINE_CODE PLINECODE1,D.PLINE_NAME,A.LOCATION_CODE,B.LOCATION_NAME,B.LOCATION_CODE AS LOCATION_CODE1,"
+ "A.STATION_CODE,C.STATION_NAME,C.STATION_CODE AS STATION_CODE1,A.LOCATION_FLAG,A.LOCATION_FLAG1,"
+ "E.INTERNAL_NAME LOCATION_FLAG_NAME,F.INTERNAL_NAME LOCATION_FLAG1_NAME FROM REL_STATION_LOCATION A "
+ " LEFT JOIN CODE_LOCATION B ON A.LOCATION_CODE =B.RMES_ID AND A.PLINE_CODE=B.PLINE_CODE LEFT JOIN CODE_STATION C ON A.STATION_CODE =C.RMES_ID AND A.PLINE_CODE=C.PLINE_CODE "
+ " LEFT JOIN CODE_PRODUCT_LINE D ON A.PLINE_CODE =D.RMES_ID "
+ " LEFT JOIN (select * from CODE_INTERNAL where internal_type_code='001') E ON A.LOCATION_FLAG=E.INTERNAL_CODE "
+ " LEFT JOIN (select * from CODE_INTERNAL where internal_type_code='002') F ON A.LOCATION_FLAG1=F.INTERNAL_CODE "
+ " WHERE A.COMPANY_CODE = '" + theCompanyCode + "' "
+ "and a.pline_code in(select w.rmes_id from VW_USER_ROLE_PROGRAM t left join code_product_line w on t.pline_code=w.pline_code "
+ "where t.user_id='" + theUserId + "' and t.program_code='" + theProgramCode + "') order by a.INPUT_TIME desc nulls last";//20161031增加时间列倒序排列
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
string sql2 = "SELECT A.*,B.LOCATION_CODE LOCATION ,C.STATION_NAME STATION from REL_STATION_LOCATION_LOG A LEFT JOIN CODE_LOCATION B on A.LOCATION_CODE =B.RMES_ID LEFT JOIN CODE_STATION C ON A.STATION_CODE =C.RMES_ID "
+ " WHERE A.COMPANY_CODE = '" + theCompanyCode + "' "
+ "and A.pline_code in(select w.rmes_id from VW_USER_ROLE_PROGRAM t left join code_product_line w on t.pline_code=w.pline_code "
+ "where t.user_id='" + theUserId + "' and t.program_code='" + theProgramCode + "') order by RQSJ desc";
DataTable dt2 = dc.GetTable(sql2);
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
}
protected void ASPxGridView2_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox NaturalPerson = ASPxGridView2.FindEditFormLayoutItemTemplateControl("PersonnePysique") as ASPxComboBox;
cn.Open();
string req = "select Id from NaturalPerson where FirstName= '" + NaturalPerson.SelectedItem.ToString() + "'";
SqlCommand cmd = new SqlCommand(req, cn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
e.NewValues["PersonnePysique_Id"] = dr["Id"].ToString();
}
cn.Close();
ASPxComboBox Adresse = ASPxGridView2.FindEditFormLayoutItemTemplateControl("PartnerDocs") as ASPxComboBox;
cn.Open();
string req1 = "select Id from PartnerDocs where DocRef= '" + Adresse.SelectedItem.ToString() + "'";
SqlCommand cmd1 = new SqlCommand(req1, cn);
SqlDataReader dr1 = cmd1.ExecuteReader();
while (dr1.Read())
{
e.NewValues["PartnerDocs_Id"] = dr1["Id"].ToString();
}
cn.Close();
}
public void GetHistSku()
{
try
{
var objInventory = new WSInventory.SwiftExpressWSInventory();
var param = string.Empty;
var fieldValues = ASPxGridView1.GetSelectedFieldValues(new[] { "SKU" });
param = fieldValues.Aggregate(param, (current, t) => current + t + ",");
//dataset para grid 2
var pResult = "";
var ds = objInventory.GetHistSku(Session["connectionString"].ToString(), param.Substring(0, param.Length - 1), ASPxDateEdit2.Date, ASPxDateEdit1.Date.AddDays(-1), ref pResult);
if (pResult == "")
{
ASPxGridView2.DataSource = ds;
Session["SKU_HIST"] = ds;
ASPxGridView2.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('" + pResult + "');", true);
}
objInventory.Dispose();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
protected void ToSelect(object sender, EventArgs e)
{
YxBtn.SetViewState(divSel);
ASPxGridView2.DataBind();
WebChartControl1.Series.Clear();
ReportData rep = new ReportData();
for (int j = ASPxDateEdit1.Date.Year; j <= ASPxDateEdit2.Date.Year; j++)
{
Series series1 = new Series(j + "年", ViewType.Line);
series1.Label.Visible = false;
for (int s = 1; s <= 12; s++)
{
bool b = false;
DataTable dt1 = rep.Report4_1(ASPxButtonEditcCus.Text.Trim(), ASPxButtonEditcInv.Text.Trim(), ASPxDateEdit1.Text, ASPxDateEdit2.Text, j.ToString());
for (int i = 0; i < dt1.Rows.Count; i++)
{
if (s.ToString() == dt1.Rows[i]["iMonth"].ToString())
{
SeriesPoint point = new SeriesPoint(dt1.Rows[i]["iMonth"].ToString() + "月", dt1.Rows[i]["iQuantity"].ToString());
series1.Points.Add(point);
b = true;
}
}
if (b == false)
{
SeriesPoint point = new SeriesPoint(s.ToString() + "月", 0);
series1.Points.Add(point);
}
}
WebChartControl1.Series.Add(series1);
}
}
protected void ASPxGridView2_RowUpdating(object sender, ASPxDataUpdatingEventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
try
{
var formLayout = ASPxGridView2.FindEditFormTemplateControl("ASPxFormLayout1") as ASPxFormLayout;
if (formLayout != null)
{
var gridLookupVendedor = formLayout.FindControl("GridLookupVendedor") as ASPxGridLookup;
var memoComentarios = formLayout.FindControl("MemoComentarios") as ASPxMemo;
var timeEditHoraVisita = formLayout.FindControl("TimeEditHoraVisita") as ASPxTimeEdit;
var spinPrioridad = formLayout.FindControl("SpinPrioridad") as ASPxSpinEdit;
var customerCode = ASPxGridView2.GetRowValuesByKeyValue(e.Keys[0], "CUSTOMER_CODE");
var customerName = ASPxGridView2.GetRowValuesByKeyValue(e.Keys[0], "CUSTOMER_NAME");
var pResult = "";
_objTask.UpdateInsertPresaleTasks(Session["connectionString"].ToString(),
customerCode.ToString(), customerName.ToString(),
gridLookupVendedor.Text, memoComentarios.Text, timeEditHoraVisita.DateTime,
ASPxCalendar1.SelectedDate, Convert.ToInt32(spinPrioridad.Number), ref pResult);
}
GetTasksByDate(ASPxCalendar1.SelectedDate);
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
ASPxGridView2.CancelEdit();
e.Cancel = true;
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridLookup uSO = ASPxGridView2.FindEditFormTemplateControl("txtSO2") as ASPxGridLookup;
ASPxTextBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxTextBox;
ASPxTextBox uPQBAK = ASPxGridView2.FindEditFormTemplateControl("txtPQBAK") as ASPxTextBox;
ASPxTextBox uREMARK = ASPxGridView2.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;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uSO = ASPxGridView2.FindEditFormTemplateControl("TextSO") as ASPxTextBox;
string strSO = uSO.Text.Trim();
string Sql = "INSERT INTO NONPPIF_ATPU (SO,input_person,input_time)VALUES( '" + strSO + "','" + theUserId + "',sysdate) ";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO NONPPIF_ATPU_LOG (SO,user_code,flag,rqsj)"
+ " SELECT SO,'" + theUserCode + "' , 'ADD', SYSDATE FROM NONPPIF_ATPU WHERE SO = '" + strSO + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!ValidarConexionYUsuarioLogueado(sender))
{
return;
}
lockupBatch.GridView.Width = 300;
if (Session["DATA_BATCH_BY_TAG"] == null)
{
GetBatchByTags();
}
else
{
ASPxGridView1.DataSource = Session["DATA_BATCH_BY_TAG"];
ASPxGridView1.DataBind();
}
if (Session["SKU_BY_BATCH"] != null)
{
ASPxGridView2.DataSource = Session["SKU_BY_BATCH"];
ASPxGridView2.DataBind();
}
if (Session["TAGS_FOR_LOOKUP"] != null)
{
lockupBatch.DataSource = Session["TAGS_FOR_LOOKUP"];
lockupBatch.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
theCompanyCode = theUserManager.getCompanyCode();
theUserId = theUserManager.getUserId();
theProgramCode = "atpu1400";
initPlineCode();
//string sql="SELECT PLAN_CODE,PLINE_CODE,BZSO,JX,GL,ZS,QFJQ 气阀进气,QFPQ 气阀排气,PL 排量,DS 怠速,XL 系列,FHCX 发火次序, "
// +"XNBH 性能表号,DYJX 打印机型,KHH 客户号,GD 固定日期,JZL 净重量,PYZS 喷油正时,EDGYL 额定供油率,HB 海拔, "
// +"ENYN 是否英文,PRSG 是否客户号代替总成号,GL1 额定功率二,ZS1 额定转速二,BYGL1 备用功率一,BYZS1 备用转速一, "
// +"BYGL2 备用功率二,BYZS2 备用转速二,NOX,PM ,KHGG 客户规格,SCXKZ 生产许可证,EPA,PFJD 排放阶段,PFJDHZH 排放阶段核准号, "
// +"FR,MPLJH 铭牌零件号,XZJD 限值阶段,DYGLD 对应功率段,ZDJGL 最大净功率,ZXBZ 执行标准,XZMC 系族名称, "
// +"XSHZHHMLY 形式核准号豁免理由,HCLZZLX 后处理装置类型 FROM atpuplannameplate";
string sql = "select * from atpuplannameplate where pline_code in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') and plan_code='" + txtPlan.Text.ToUpper() + "'";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
string sql2 = "SELECT * FROM COPY_VEPS_DATA where so='" + txtSoQry.Text.Trim().ToUpper() + "'";
DataTable dt2 = dc.GetTable(sql2);
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
}
private void initBom()
{
string sql = "select ljbgy ,ljdm ,ljmc ,ljdd ,ljgw ,ljsl ,rowid from RST_QAD_TEMPPRTPART where jhdm='GZ" + txtPlanCode2.Text + "'";
ASPxGridView2.DataSource = dc.GetTable(sql);
ASPxGridView2.DataBind();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox uJX = ASPxGridView2.FindEditFormTemplateControl("txtJX") as ASPxComboBox;
ASPxComboBox uPD = ASPxGridView2.FindEditFormTemplateControl("txtPD") as ASPxComboBox;
string strJX = uJX.Value.ToString();
string strPD = uPD.Value.ToString();
string Sql = "INSERT INTO JWYF (JXREMARK,PANDUAN,INPUT_PERSON,INPUT_TIME) "
+ "VALUES('" + strJX + "', '" + strPD + "','" + theUserId + "',SYSDATE)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO JWYF_LOG (JXREMARK,PANDUAN,user_code,flag,rqsj)"
+ " VALUES('" + strJX + "', '" + strPD + "','" + theUserCode + "' , 'ADD', SYSDATE) ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
private void setCondition()
{
//初始化GRIDVIEW
//string sql = "SELECT '装配重要零件' as ZYLJLB, A.LJDM,A.LJMC,A.XH,A.GZDD,A.LJLB,B.PLINE_NAME,B.PLINE_CODE FROM DMZYLJB A "
// + " LEFT JOIN CODE_PRODUCT_LINE B ON A.GZDD=B.PLINE_CODE "
// + " WHERE A.GZDD in(SELECT PLINE_CODE FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' "
// + "and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')"
// + " union SELECT '检查重要零件' as ZYLJLB, C.LJDM,C.LJMC,C.XH,C.GZDD,'' as LJLB,D.PLINE_NAME,D.PLINE_CODE FROM DMJCLJB C "
// + " LEFT JOIN CODE_PRODUCT_LINE D ON C.GZDD=D.PLINE_CODE "
// + " WHERE C.GZDD in(SELECT PLINE_CODE FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' "
// +"and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')"
// + " ORDER BY ZYLJLB,GZDD,LJDM";
string sql = "SELECT * from vw_zyljb WHERE GZDD in(SELECT PLINE_CODE FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' "
+ "and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') "
+ " ORDER BY INPUT_TIME DESC NULLS LAST ";
DataTable dt = dc.GetTable(sql);
ASPxGridView1.DataSource = dt;
ASPxGridView1.DataBind();
initLJDM();
initPline();
initLJLB();
initLJJB();
//新增的按零件名称维护标签页 YXH
string sql2 = "SELECT * from DMZYLJB_NAME WHERE PLINE_CODE in(SELECT PLINE_CODE FROM VW_USER_ROLE_PROGRAM WHERE USER_ID='" + theUserId + "' "
+ "and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "') ORDER BY INPUT_TIME DESC NULLS LAST";
DataTable dt2 = dc.GetTable(sql2);
ASPxGridView2.DataSource = dt2;
ASPxGridView2.DataBind();
}
protected void AspxMenu1_ItemClick(object source, DevExpress.Web.MenuItemEventArgs e)
{
switch (e.Item.Name)
{
case "btnNew":
Session["GridManifiesto"] = null;
ASPxGridView2.DataSource = null;
ASPxGridView2.DataBind();
GetPicking();
break;
case "btnExcel":
ASPxGridViewExporter1.WriteXlsxToResponse();
break;
case "btnPdf":
ASPxGridViewExporter1.Landscape = true;
ASPxGridViewExporter1.WritePdfToResponse();
break;
case "btnReport":
ReportViewer();
ASPxPopupControl1.ShowOnPageLoad = true;
break;
}
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox plineCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox ljmc = ASPxGridView2.FindEditFormTemplateControl("txtName") as ASPxTextBox;
//取RMES_ID的值
string sql_rmes_id = "SELECT SEQ_RMES_ID.NEXTVAL FROM DUAL ";
dc.setTheSql(sql_rmes_id);
string rmes_id = dc.GetTable().Rows[0][0].ToString();
string Sql = "";
Sql = "INSERT INTO DMZYLJB_NAME (RMES_ID,LJMC,PLINE_CODE,INPUT_PERSON,INPUT_TIME)"
+ "VALUES('" + rmes_id + "', '" + ljmc.Text.Trim() + "','" + plineCode.Value.ToString() + "','"+theUserId+"',SYSDATE)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO DMZYLJB_NAME_LOG (RMES_ID,LJMC,PLINE_CODE,user_code,flag,rqsj)"
+ " SELECT RMES_ID,LJMC,PLINE_CODE,'" + theUserCode + "' , 'ADD', SYSDATE FROM DMZYLJB_NAME WHERE RMES_ID = '" + rmes_id + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
protected void ASPxGridView2_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox plineCode = ASPxGridView2.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox ljmc = ASPxGridView2.FindEditFormTemplateControl("txtName") as ASPxTextBox;
ASPxComboBox partNAME_ABC = ASPxGridView2.FindEditFormTemplateControl("comboLJLB_NAME") as ASPxComboBox;
string Sql = "INSERT INTO ATPUSMLJB (PLINE_CODE,ABOM_DESC,PART_ABC,INPUT_PERSON,INPUT_TIME) "
+ "VALUES( '" + plineCode.Value.ToString() + "','" + ljmc.Text.Trim() + "','" + partNAME_ABC.Value.ToString() + "','" + theUserId + "',SYSDATE)";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUSMLJB_LOG (PLINE_CODE,ABOM_DESC,PART_ABC,user_code,flag,rqsj)"
+ " SELECT PLINE_CODE,ABOM_DESC,PART_ABC,'" + theUserCode + "' , 'ADD', SYSDATE FROM ATPUSMLJB "
+ "WHERE PLINE_CODE = '" + plineCode.Value.ToString() + "' and ABOM_DESC = '" + ljmc.Text.Trim() + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView2.CancelEdit();
setCondition();
}
public void GetLocation(string codeWarehouse)
{
try
{
var pResult = "";
var ds = _objLocation.GetLocation(Session["connectionString"].ToString(), codeWarehouse, ref pResult);
if (pResult == "")
{
ASPxGridView2.DataSource = ds.Tables[0];
var regionCombo =
(ASPxGridView2.Columns["CLASSIFICATION_LOCATION"] as GridViewDataComboBoxColumn);
if (regionCombo != null)
{
regionCombo.PropertiesComboBox.DataSource = ds.Tables[0].DefaultView.ToTable(true, "CLASSIFICATION_LOCATION");
regionCombo.PropertiesComboBox.ValueField = "CLASSIFICATION_LOCATION";
regionCombo.PropertiesComboBox.TextField = "CLASSIFICATION_LOCATION";
}
ASPxGridView2.DataBind();
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText",
"CallError('" + pResult + "');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, GetType(), "ErrorText", "CallError('Error: " + ex.Message + "');", true);
}
}
