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_CellEditorInitialize(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditorEventArgs e)
{
ASPxGridView aspx1 = sender as ASPxGridView;
//aspx1.KeyFieldName = "LJDM1";
if (ASPxGridView2.IsEditing)
{
string rowid1 = "";
try
{
rowid1 = (string)ASPxGridView2.GetRowValuesByKeyValue(e.KeyValue, "ROWID");
}
catch { }
string LJDM1 = "";
try
{
LJDM1 = dc.GetValue("select ljdm1 from SJBOMSOTHMUTI where so='" + Request["so"].ToString() + "' and jhdm='" + Request["planCode"].ToString()
+ "' and rowid='" + rowid1 + "' ");
//LJDM1 = (string)ASPxGridView2.GetRowValuesByKeyValue(e.KeyValue, "LJDM1");
}
catch { }
if (e.Column.FieldName == "GWMC")
{
ASPxComboBox combo = e.Editor as ASPxComboBox;
string sql = "select location_code from data_plan_standard_Bom where plan_code='" + Request["planCode"].ToString() + "' and item_code='" + LJDM1 + "' order by location_code";
DataTable dt = dc.GetTable(sql);
combo.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
combo.Items.Add(dt.Rows[i]["location_code"].ToString(), dt.Rows[i]["location_code"].ToString());
}
}
if (e.Column.FieldName == "GWMC1")
{
ASPxComboBox combo = e.Editor as ASPxComboBox;
string sql = "select distinct location_code from data_plan_standard_Bom where plan_code='" + Request["planCode"].ToString() + "' order by location_code ";
DataTable dt = dc.GetTable(sql);
combo.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
combo.Items.Add(dt.Rows[i]["location_code"].ToString(), dt.Rows[i]["location_code"].ToString());
}
}
if (e.Column.FieldName == "GXMC1")
{
ASPxComboBox combo = e.Editor as ASPxComboBox;
string GWMC1 = "";
GWMC1 = dc.GetValue("select gwmc1 from SJBOMSOTHMUTI where so='" + Request["so"].ToString() + "' and jhdm='" + Request["planCode"].ToString()
+ "' and rowid='" + rowid1 + "' ");
string sql = "select distinct process_code from data_plan_standard_Bom where plan_code='" + Request["planCode"].ToString() + "' and location_code='" + GWMC1 + "' order by process_code";
dc.setTheSql(sql);
DataTable dt = dc.GetTable();
combo.Items.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
combo.Items.Add(dt.Rows[i]["process_code"].ToString(), dt.Rows[i]["process_code"].ToString());
}
combo.Callback += new CallbackEventHandlerBase(cmbGXMC1_OnCallback);
}
}
}
