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);
}
}
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();
}
public void getEmployeeTableCopy()
{
string keyValueGrid = "";
for (int i = 0; i < ASPxGridView2.VisibleRowCount; i++)
{
if (ASPxGridView2.Selection.IsRowSelected(i))
{
keyValueGrid = ASPxGridView2.GetRowValues(i, "ddlKey").ToString();
treatmentCopyTo.Items.FindByValue(keyValueGrid).Selected = true;
}
}
}
protected void ASPxGridView2_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomButtonCallbackEventArgs e)
{
bool move = e.ButtonID == "sy" ? true : false;
int PROCESSID = Convert.ToInt32(ASPxGridView2.GetRowValues(e.VisibleIndex, "PROCESSID"));
GhtnTech.SEP.OraclDAL.DALPROCESS pro = new GhtnTech.SEP.OraclDAL.DALPROCESS();
DataTable dt = pro.GetDALPROCESS(" and PROCESSID=" + PROCESSID.ToString()).Tables[0];
int sort = Convert.ToInt32(dt.Rows[0]["SERIALNUMBER"]);
int WORKTASKID = Convert.ToInt32(dt.Rows[0]["WORKTASKID"]);
try
{
//修改后-删除某记录后也可进行排序
DataSet ds = OracleHelper.Query("select SERIALNUMBER from (select SERIALNUMBER from PROCESS where WORKTASKID='" + WORKTASKID + "' order by SERIALNUMBER desc nulls last) where ROWNUM = 1");
for (int i = 1; i <= int.Parse(ds.Tables[0].Rows[0]["SERIALNUMBER"].ToString()); i++)
{
int otherID = -1;
try
{
DataSet dsP = pro.GetDALPROCESS(" and WORKTASKID = " + WORKTASKID.ToString() + " and SERIALNUMBER = " + Convert.ToString(move ? sort - i : sort + i));
otherID = Convert.ToInt32(dsP.Tables[0].Rows[0]["PROCESSID"].ToString());
}
catch
{
continue;
}
pro.UpdateDALPROCESS_SERIALNUMBER(PROCESSID, move ? sort - i : sort + i);
pro.UpdateDALPROCESS_SERIALNUMBER(otherID, sort);
break;
}
ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = "and WORKTASKID = " + WORKTASKID + "";
ASPxGridView2.DataSourceID = "ObjectDataSource1";
ASPxGridView2.DataBind();
//连号方可排序
//int otherID = Convert.ToInt32(pro.GetDALPROCESS(" and WORKTASKID=" + WORKTASKID.ToString() + " and SERIALNUMBER=" + Convert.ToString(move ? sort - 1 : sort + 1)).Tables[0].Rows[0]["PROCESSID"]);
//pro.UpdateDALPROCESS_SERIALNUMBER(PROCESSID, move ? sort - 1 : sort + 1);
//pro.UpdateDALPROCESS_SERIALNUMBER(otherID, sort);
//ObjectDataSource1.SelectParameters["strWhere"].DefaultValue = "and WORKTASKID = " + WORKTASKID + "";
//ASPxGridView2.DataSourceID = "ObjectDataSource1";
//ASPxGridView2.DataBind();
}
catch
{
string msg = move ? "当前是第一行，无法上移" : "当前是最后一行，无法下移";
throw new Exception(msg);
}
}
//创建EDITFORM前
protected void ASPxGridView2_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
if (!ASPxGridView2.IsNewRowEditing && ASPxGridView2.IsEditing)
{
///主键不可以修改
(ASPxGridView2.FindEditFormTemplateControl("comboLJDM2") as ASPxComboBox).Enabled = false;
//处理ASPxCheckBox
if (ASPxGridView2.GetRowValues(ASPxGridView2.FocusedRowIndex, "SFXS").ToString() == "1")
{
(ASPxGridView2.FindEditFormTemplateControl("chZCFlag") as ASPxCheckBox).Checked = true;
}
else
{
(ASPxGridView2.FindEditFormTemplateControl("chZCFlag") as ASPxCheckBox).Checked = false;
}
}
}
public void ASPxGridView2_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e)
{
string s = e.Parameters;
string[] s1 = s.Split('|');
string type1 = s1[0];
int rowIndex = int.Parse(s1[1]);
string rmesid = ASPxGridView2.GetRowValues(rowIndex, "RMES_ID").ToString();
switch (type1)
{
case "Treated2":
string sql = "update DATA_SN_BOM_TEMP set CONFIRM_FLAG='N' where rmes_id='" + rmesid + "'";
dc.ExeSql(sql);
string sql2 = "delete from DATA_SN_BOM where rmes_id = '" + rmesid + "' ";
dc.ExeSql(sql2);
break;
case "Untreated2":
string sql4 = "insert into DATA_SN_BOM select * from DATA_SN_BOM_TEMP WHERE RMES_ID= '" + rmesid + "'";
dc.ExeSql(sql4);
string sql5 = "delete from DATA_SN_BOM_TEMP where rmes_id = '" + rmesid + "' ";
dc.ExeSql(sql5);
break;
default:
break;
}
}
