protected void ASPxGridView1_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxComboBox uPcode = ASPxGridView1.FindEditFormTemplateControl("dropPlineCode") as ASPxComboBox;
string Sql2 = "select PLINE_CODE,PLINE_CODE||' '||pline_name as showtext from CODE_PRODUCT_LINE where pline_code in (select pline_code from vw_user_role_program where user_id='" + theUserId + "' and program_code='" + theProgramCode + "' and company_code='" + theCompanyCode + "')";
DataTable dt2 = dc.GetTable(Sql2);
uPcode.DataSource = dt2;
uPcode.TextField = dt2.Columns[1].ToString();
uPcode.ValueField = dt2.Columns[0].ToString();
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
///主键不可以修改
(ASPxGridView1.FindEditFormTemplateControl("txtShiftCode") as ASPxTextBox).Enabled = false;
if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "IS_CROSS_DAY").ToString() == "1")
{
(ASPxGridView1.FindEditFormTemplateControl("chkCrossDay") as ASPxCheckBox).Checked = true;
}
else
{
(ASPxGridView1.FindEditFormTemplateControl("chkCrossDay") as ASPxCheckBox).Checked = false;
}
}
else
{
(ASPxGridView1.FindEditFormTemplateControl("chkCrossDay") as ASPxCheckBox).Checked = false;
//uPcode.SelectedIndex = 0;
}
}
public void cargarDistritos()
{
ASPxPageControl tabs = (ASPxPageControl)ASPxGridView1.FindEditFormTemplateControl("pageControl");
ASPxFormLayout form = (ASPxFormLayout)tabs.FindControl("formLayoutUbicacion");
/* PROVINCIA */
ASPxComboBox comboProvincia = (ASPxComboBox)form.FindControl("cmbProvincia");
/* CANTON */
ASPxComboBox comboCanton = (ASPxComboBox)form.FindControl("cmbCanton");
/* DISTRITO */
ASPxComboBox comboDistrito = (ASPxComboBox)form.FindControl("cmbDistrito");
comboDistrito.Items.Clear();
if (comboProvincia.Value != null && comboCanton.Value != null)
{
using (var conexion = new DataModelFE())
{
foreach (var item in conexion.Ubicacion.
Where(x => x.codProvincia == comboProvincia.Value.ToString()).
Where(x => x.codCanton == comboCanton.Value.ToString()).
Select(x => new { x.codDistrito, x.nombreDistrito }).Distinct())
{
comboDistrito.Items.Add(item.nombreDistrito, item.codDistrito);
}
comboDistrito.IncrementalFilteringMode = IncrementalFilteringMode.Contains;
comboDistrito.SelectedIndex = 0;
}
}
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uCode = ASPxGridView1.FindEditFormTemplateControl("txtShiftCode") as ASPxTextBox;
ASPxTextBox uName = ASPxGridView1.FindEditFormTemplateControl("txtShiftName") as ASPxTextBox;
ASPxTextBox sTime = ASPxGridView1.FindEditFormTemplateControl("txtBeginTime") as ASPxTextBox;
ASPxTextBox eTime = ASPxGridView1.FindEditFormTemplateControl("txtEndTime") as ASPxTextBox;
ASPxComboBox uPcode = ASPxGridView1.FindEditFormTemplateControl("dropPlineCode") as ASPxComboBox;
ASPxCheckBox chkCrossDay = ASPxGridView1.FindEditFormTemplateControl("chkCrossDay") as ASPxCheckBox;
ASPxTextBox mHour = ASPxGridView1.FindEditFormTemplateControl("txtManHour") as ASPxTextBox;
string vFlag = "";
if (chkCrossDay.Checked == true)
{
vFlag = "Y";
}
else
{
vFlag = "N";
}
string Sql = "INSERT INTO CODE_SHIFT (COMPANY_CODE,SHIFT_CODE,SHIFT_NAME,BEGIN_TIME,END_TIME,PLINE_CODE,IS_CROSS_DAY,SHIFT_MANHOUR) "
+ "VALUES('" + theCompanyCode + "','" + uCode.Text.Trim().ToUpper() + "','" + uName.Text.Trim() + "','" + sTime.Text.ToString() + "','" + eTime.Text.ToString() + "','" + uPcode.Value.ToString() + "','" + vFlag + "','" + mHour.Text.Trim() + "')";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxTextBox uCXH = ASPxGridView1.FindEditFormTemplateControl("txtCXH") as ASPxTextBox;
ASPxTextBox txtFR = ASPxGridView1.FindEditFormTemplateControl("txtFR") as ASPxTextBox;
ASPxTextBox txtsat = ASPxGridView1.FindEditFormTemplateControl("txtSAT") as ASPxTextBox;
string strFR = txtFR.Text.Trim();
string Sql = "INSERT INTO ATPUFRCXH (FR,CXH,INPUT_PERSON,INPUT_TIME,sat) "
+ "VALUES( '" + strFR.ToUpper() + "', '" + uCXH.Text.Trim() + "','" + theUserId + "',sysdate,'" + txtsat.Text.Trim() + "')";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO ATPUFRCXH_LOG (fr,cxh,user_code,flag,rqsj,sat)"
+ " SELECT fr,cxh,'" + theUserCode + "' , 'ADD', SYSDATE,sat FROM ATPUFRCXH WHERE FR = '" + strFR.ToUpper() + "' ";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
// 进入修改界面时的处理
protected void ASPxGridView1_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxComboBox dropPline = ASPxGridView1.FindEditFormTemplateControl("dropPlineCode") as ASPxComboBox;
ASPxComboBox dropLeader = ASPxGridView1.FindEditFormTemplateControl("dropTeamLeader") as ASPxComboBox;
string Sql1 = "select pline_code,pline_code||' '||pline_name as showtext from CODE_PRODUCT_LINE 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 pline_name";
DataTable dt1 = theDc.GetTable(Sql1);
dropPline.DataSource = dt1;
dropPline.TextField = dt1.Columns[1].ToString();
dropPline.ValueField = dt1.Columns[0].ToString();
string Sql2 = "select USER_CODE,USER_NAME from CODE_USER where user_type='B' order by nlssort(USER_NAME,'NLS_SORT=SCHINESE_PINYIN_M')";
DataTable dt2 = theDc.GetTable(Sql2);
dropLeader.DataSource = dt2;
dropLeader.TextField = dt2.Columns[1].ToString();
dropLeader.ValueField = dt2.Columns[0].ToString();
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
///主键不可以修改
(ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxTextBox).Enabled = false;
}
else
{
dropPline.SelectedIndex = 0;
dropLeader.SelectedIndex = 0;
}
}
// 新增
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxComboBox pUserID = ASPxGridView1.FindEditFormTemplateControl("drpUID") as ASPxComboBox;
ASPxComboBox pTagCode = ASPxGridView1.FindEditFormTemplateControl("drpTagCode") as ASPxComboBox;
ASPxCheckBox chkTagFlag = ASPxGridView1.FindEditFormTemplateControl("chkTagFlag") as ASPxCheckBox;
//string tagCodeFather = theDC.GetTable("SELECT * FROM CODE_TAG WHERE TAG_CODE='" + pTagCode + "'").Rows[0]["TAG_CODE_FATHER"].ToString();
string tagFlag = "";
if (chkTagFlag.Checked == true)
{
tagFlag = "Y";
}
else
{
tagFlag = "N";
}
string inSql = "INSERT INTO REL_USER_TAG (COMPANY_CODE, USER_ID,TAG_CODE,TAG_FLAG) "
+ "VALUES('" + theCompanyCode + "','" + pUserID.Value.ToString().Trim() + "','" + pTagCode.Value.ToString().Trim() + "','" + tagFlag + "')";
theDC.ExeSql(inSql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
queryFunction();
}
// 进入修改界面时的处理
protected void ASPxGridView1_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxComboBox drpUserID = ASPxGridView1.FindEditFormTemplateControl("drpUID") as ASPxComboBox;
ASPxComboBox drpTagCode = ASPxGridView1.FindEditFormTemplateControl("drpTagCode") as ASPxComboBox;
string Sql = "SELECT USER_ID,USER_NAME AS SHOWTEXT FROM CODE_USER";
DataTable dt1 = theDC.GetTable(Sql);
drpUserID.DataSource = dt1;
drpUserID.TextField = dt1.Columns[1].ToString();
drpUserID.ValueField = dt1.Columns[0].ToString();
Sql = "SELECT TAG_CODE,TAG_NAME AS SHOWTEXT FROM CODE_TAG";
DataTable dt2 = theDC.GetTable(Sql);
drpTagCode.DataSource = dt2;
drpTagCode.TextField = dt2.Columns[1].ToString();
drpTagCode.ValueField = dt2.Columns[0].ToString();
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
//主键不可以修改
(ASPxGridView1.FindEditFormTemplateControl("drpUID") as ASPxComboBox).Enabled = false;
(ASPxGridView1.FindEditFormTemplateControl("drpTagCode") as ASPxComboBox).Enabled = false;
///处理ASPxCheckBox
if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "TAG_FLAG").ToString() == "Y")
{
(ASPxGridView1.FindEditFormTemplateControl("chkTagFlag") as ASPxCheckBox).Checked = true;
}
else
{
(ASPxGridView1.FindEditFormTemplateControl("chkTagFlag") as ASPxCheckBox).Checked = false;
}
}
}
//新增
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
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
//修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxTextBox uPmCode = ASPxGridView1.FindEditFormTemplateControl("TextPmCode") as ASPxTextBox;
ASPxTextBox uPmValue = ASPxGridView1.FindEditFormTemplateControl("TextPmValue") as ASPxTextBox;
ASPxTextBox uPmDesc = ASPxGridView1.FindEditFormTemplateControl("TextPmDesc") as ASPxTextBox;
ASPxTextBox uPmTemp02 = ASPxGridView1.FindEditFormTemplateControl("TextPmTemp02") as ASPxTextBox;
ASPxTextBox uGzdd = ASPxGridView1.FindEditFormTemplateControl("TextGzdd") as ASPxTextBox;
ASPxDateEdit dPmValue = ASPxGridView1.FindEditFormTemplateControl("DatePmValue") as ASPxDateEdit;
string strPmCode = uPmCode.Text.Trim();
string strPmValue = uPmValue.Text.Trim();
string strPmDesc = uPmDesc.Text.Trim();
string strPmTemp02 = uPmTemp02.Text.Trim();
string strGzdd = uGzdd.Text.Trim();
//插入到日志表
try
{
string Sql2 = "INSERT INTO MS_JIT_PARAMETER_LOG (PARAMETER_CODE,PARAMETER_VALUE,PARAMETER_DESC,TEMP01,TEMP02,GZDD,user_code,flag,rqsj)"
+ " SELECT PARAMETER_CODE,PARAMETER_VALUE,PARAMETER_DESC,TEMP01,TEMP02,GZDD,'"
+ theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM MS_JIT_PARAMETER WHERE PARAMETER_CODE = '" + strPmCode + "' and GZDD = '" + strGzdd + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
if (strPmCode == "$INNER_INIT_CALCULATE_TIME" || strPmCode == "$THIRD_INIT_CALCULATE_TIME" || strPmCode == "$THIRD_INIT_PLANDATE" || strPmCode == "$INNER_INIT_PLANDATE")
{
//TextPmDesc.Visible = false;
string Sql = "UPDATE MS_JIT_PARAMETER SET PARAMETER_DESC='" + strPmDesc + "',parameter_value='" + dPmValue.Text + "',temp02='" + strPmTemp02 + "' "
+ " WHERE PARAMETER_CODE = '" + strPmCode + "' and GZDD = '" + strGzdd + "'";
dc.ExeSql(Sql);
}
else
{
string Sql = "UPDATE MS_JIT_PARAMETER SET PARAMETER_DESC='" + strPmDesc + "',parameter_value='" + strPmValue + "',temp02='" + strPmTemp02 + "',input_person='" + theUserId + "',input_time=sysdate "
+ " WHERE PARAMETER_CODE = '" + strPmCode + "' and GZDD = '" + strGzdd + "'";
dc.ExeSql(Sql);
}
//插入到日志表
try
{
string Sql2 = "INSERT INTO MS_JIT_PARAMETER_LOG (PARAMETER_CODE,PARAMETER_VALUE,PARAMETER_DESC,TEMP01,TEMP02,GZDD,user_code,flag,rqsj)"
+ " SELECT PARAMETER_CODE,PARAMETER_VALUE,PARAMETER_DESC,TEMP01,TEMP02,GZDD,'"
+ theUserCode + "' , 'AFTEREDIT', SYSDATE FROM MS_JIT_PARAMETER WHERE PARAMETER_CODE = '" + strPmCode + "' and GZDD = '" + strGzdd + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void gridInterviewDet_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
ASPxTextBox id = ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
e.NewValues["InterviewId"] = SafeValue.SafeString("<" + id.Text + ">", "");
e.NewValues["RecruitId"] = "";
e.NewValues["Gender"] = "Male";
}
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
///主键不可以修改
(ASPxGridView1.FindEditFormTemplateControl("txtVendorCode") as ASPxTextBox).Enabled = false;
}
}
protected void ASPxGridView1_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
//e.NewValues["HC_FLAG"];
(ASPxGridView1.FindEditFormTemplateControl("txtHcFLAG") as ASPxComboBox).SelectedIndex = 1;
(ASPxGridView1.FindEditFormTemplateControl("txtLqFlag") as ASPxComboBox).SelectedIndex = 1;
(ASPxGridView1.FindEditFormTemplateControl("txtPackFlag") as ASPxComboBox).SelectedIndex = 1;
(ASPxGridView1.FindEditFormTemplateControl("txtTName") as ASPxComboBox).SelectedIndex = 0;
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
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.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.Insert(detEntity);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
e.NewValues["ID"] = Guid.NewGuid().ToString().Replace("-", "");
ASPxHtmlEditor htmlEditor = ASPxGridView1.FindEditFormTemplateControl("ASPxHtmlEditor1") as ASPxHtmlEditor;
e.NewValues["DescriptionHtml"] = htmlEditor.Html;
}
//修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox ljdm = ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxComboBox;
ASPxDateEdit begindate1 = ASPxGridView1.FindEditFormTemplateControl("dateStart") as ASPxDateEdit;
ASPxDateEdit enddate1 = ASPxGridView1.FindEditFormTemplateControl("dateEnd") as ASPxDateEdit;
ASPxCheckBox chZCXSFlag = ASPxGridView1.FindEditFormTemplateControl("chZCFlag") as ASPxCheckBox;
string xsFlag = "";
if (chZCXSFlag.Checked == true)
{
xsFlag = "1";
}
else
{
xsFlag = "0";
}
ASPxCheckBox chHCXSFlag = ASPxGridView1.FindEditFormTemplateControl("chHCFlag") as ASPxCheckBox;
string hcFlag = "";
if (chHCXSFlag.Checked == true)
{
hcFlag = "1";
}
else
{
hcFlag = "0";
}
ASPxCheckBox chHCZCFlag = ASPxGridView1.FindEditFormTemplateControl("chHCZCFlag") as ASPxCheckBox;
string hcZCFlag = "";
if (chHCZCFlag.Checked == true && chHCXSFlag.Checked == true)
{
hcZCFlag = "1";
}
else
{
hcZCFlag = "0";
}
string Sql = "UPDATE ATPUBOMKZB SET rqbegin=to_date('" + begindate1.Text.Trim() + "','yyyy-MM-dd'),rqend=to_date('" + enddate1.Text.Trim() + "','yyyy-MM-dd'), "
+ "SFXS='" + xsFlag + "',SFHC='" + hcFlag + "',SFZC='" + hcZCFlag + "' WHERE abom_comp = '" + ljdm.Value.ToString() + "'";
dc.ExeSql(Sql);
//记录操作start
string logSql = "insert into atpubomkzb_log(abom_comp,zdrq,rqbegin,rqend,SFXS,SFHC,SFZC,rqsj,yhmc,czms) "
+ " select abom_comp,zdrq,rqbegin,rqend,SFXS,SFHC,SFZC,sysdate,'" + theUserName + "','修改了该零件' "
+ " from atpubomkzb where abom_comp='" + ljdm.Value.ToString() + "' ";
dc.ExeSql(logSql);
//记录操作end
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition1();
}
//创建EDITFORM前
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
///主键不可以修改
(ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxComboBox).Enabled = false;
//处理ASPxCheckBox
string a = ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQEND").ToString();
if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQEND").ToString() != "")
{
(ASPxGridView1.FindEditFormTemplateControl("chValidFlag") as ASPxCheckBox).Checked = true;
}
else
{
(ASPxGridView1.FindEditFormTemplateControl("chValidFlag") as ASPxCheckBox).Checked = false;
}
if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQBEGIN").ToString() != "")
{
theBeginDate = Convert.ToDateTime(ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQBEGIN").ToString());
}
if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQEND").ToString() != "")
{
theEndDate = Convert.ToDateTime(ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "RQEND").ToString());
}
//处理ASPxCheckBox
if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "SFXS").ToString() == "1")
{
(ASPxGridView1.FindEditFormTemplateControl("chZCFlag") as ASPxCheckBox).Checked = true;
}
else
{
(ASPxGridView1.FindEditFormTemplateControl("chZCFlag") as ASPxCheckBox).Checked = false;
}
//处理ASPxCheckBox
if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "SFHC").ToString() == "1")
{
(ASPxGridView1.FindEditFormTemplateControl("chHCFlag") as ASPxCheckBox).Checked = true;
}
else
{
(ASPxGridView1.FindEditFormTemplateControl("chHCFlag") as ASPxCheckBox).Checked = false;
}
//处理ASPxCheckBox
if (ASPxGridView1.GetRowValues(ASPxGridView1.FocusedRowIndex, "SFZC").ToString() == "1")
{
(ASPxGridView1.FindEditFormTemplateControl("chHCZCFlag") as ASPxCheckBox).Checked = true;
}
else
{
(ASPxGridView1.FindEditFormTemplateControl("chHCZCFlag") as ASPxCheckBox).Checked = false;
}
}
}
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup;
gridLookupUser.GridView.Width = 250;
ASPxGridLookup gridLookupRole = ASPxGridView1.FindEditFormTemplateControl("GridLookupRole") as ASPxGridLookup;
gridLookupRole.GridView.Width = 250;
}
//创建EDITFORM前
//初始化入出库类型combobox
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
string sql = "SELECT LXMC FROM DP_RKLX ORDER BY LXDM ";
DataTable dt = dc.GetTable(sql);
ASPxComboBox cb_Rklx = ASPxGridView1.FindEditFormTemplateControl("txtRklx") as ASPxComboBox;
cb_Rklx.DataSource = dt;
cb_Rklx.TextField = dt.Columns[0].ToString();
cb_Rklx.ValueField = dt.Columns[0].ToString();
}
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
//主键不可以修改
(ASPxGridView1.FindEditFormTemplateControl("pro") as ASPxTextBox).Enabled = false;
//按照之前开发的样子，生产线也不可以修改
//(ASPxGridView1.FindEditFormTemplateControl("ASPxComboBox1") as ASPxComboBox).Enabled = false;
}
}
//创建EDITFORM前
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
string Sql = " select distinct a.pline_code,a.pline_code||' '||b.pline_name as showtext from vw_user_role_program a left join code_product_line b on a.pline_code=b.pline_code where a.user_id='" + theUserId + "' and a.program_code='" + theProgramCode + "' and a.company_code='" + theCompanyCode + "' ";
DataTable dt = dc.GetTable(Sql);
ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
uPCode.DataSource = dt;
uPCode.TextField = dt.Columns[1].ToString();
uPCode.ValueField = dt.Columns[0].ToString();
}
protected void grid_PayrollDet_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
if (SafeValue.SafeString(e.NewValues["ChgCode"], "") == "")
{
throw new Exception("ChgCode not be null !!!");
}
ASPxTextBox id = ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
e.NewValues["PayrollId"] = SafeValue.SafeInt(id.Text, 0);
e.NewValues["Amt"] = SafeValue.SafeDecimal(e.NewValues["Amt"], 0);
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
ASPxButtonEdit doNo = ASPxGridView1.FindEditFormTemplateControl("txt_DoNo") as ASPxButtonEdit;
e.NewValues["JobType"] = "OUT";
e.NewValues["RefNo"] = doNo.Text;
e.NewValues["ChgCode"] = SafeValue.SafeString(e.NewValues["ChgCode"]);
e.NewValues["ChgCodeDes"] = SafeValue.SafeString(e.NewValues["ChgCodeDes"]);
e.NewValues["Remark"] = SafeValue.SafeString(e.NewValues["Remark"]);
e.NewValues["CostDocAmt"] = SafeValue.ChinaRound(SafeValue.SafeDecimal(e.NewValues["CostQty"], 0) * SafeValue.SafeDecimal(e.NewValues["CostPrice"], 0), 2);
e.NewValues["CostLocAmt"] = SafeValue.ChinaRound(SafeValue.SafeDecimal(e.NewValues["CostDocAmt"], 0) * SafeValue.SafeDecimal(e.NewValues["CostExRate"], 0), 2);
}
//修改
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox txtTCL = ASPxGridView1.FindEditFormTemplateControl("txtTCL") as ASPxTextBox;
ASPxTextBox txtTCL1 = ASPxGridView1.FindEditFormTemplateControl("txtTCL1") as ASPxTextBox;
ASPxTextBox txtJX = ASPxGridView1.FindEditFormTemplateControl("txtJX") as ASPxTextBox;
ASPxTextBox txtGNUM = ASPxGridView1.FindEditFormTemplateControl("txtGNUM") as ASPxTextBox;
ASPxComboBox txtSO = ASPxGridView1.FindEditFormTemplateControl("txtSO") as ASPxComboBox;
ASPxTextBox txtBZ = ASPxGridView1.FindEditFormTemplateControl("txtBZ") as ASPxTextBox;
string strPCode = uPCode.Value.ToString();
string strTCL = txtTCL.Text.Trim();
string strTCL1 = txtTCL1.Text.Trim();
string strJX = txtJX.Text.Trim();
string strGNUM = txtGNUM.Text.Trim();
string strBZ = txtBZ.Text.Trim();
string strSO = txtSO.Value.ToString();
//插入到日志表
try
{
string Sql2 = "INSERT INTO JWTCMSO_LOG (PLINE_CODE,SO,JX,TCL,TCL1,REMARK,GNUM,user_code,flag,rqsj)"
+ " SELECT PLINE_CODE,SO,JX,TCL,TCL1,REMARK,GNUM,'" + theUserCode + "' , 'BEFOREEDIT', SYSDATE FROM JWTCMSO WHERE SO = '" + strSO + "'";
dc.ExeSql(Sql2);
}
catch
{
return;
}
string Sql = "UPDATE JWTCMSO SET PLINE_CODE='" + strPCode + "',JX='" + strJX + "',TCL='" + strTCL + "',TCL1='" + strTCL1 + "',REMARK='" + strBZ + "',GNUM='" + strGNUM + "',INPUT_PERSON='" + theUserId + "',INPUT_TIME=SYSDATE"
+ " WHERE SO = '" + strSO + "'";
dc.ExeSql(Sql);
//插入到日志表
try
{
string Sql2 = "INSERT INTO JWTCMSO_LOG (PLINE_CODE,SO,JX,TCL,TCL1,REMARK,GNUM,user_code,flag,rqsj)"
+ " SELECT PLINE_CODE,SO,JX,TCL,TCL1,REMARK,GNUM,'" + theUserCode + "' , 'AFTEREDIT', SYSDATE FROM JWTCMSO WHERE SO = '" + strSO + "'";
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("txtPCode") as ASPxTextBox;
//ASPxTextBox uName = ASPxGridView1.FindEditFormTemplateControl("txtPName") as ASPxTextBox;
//string strCode = uCode.Text.Trim();
//string strName = uName.Text.Trim();
ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox;
ASPxTextBox uSCode = ASPxGridView1.FindEditFormTemplateControl("txtSCode") as ASPxTextBox;
ASPxTextBox uSName = ASPxGridView1.FindEditFormTemplateControl("txtSName") as ASPxTextBox;
ASPxComboBox uSType = ASPxGridView1.FindEditFormTemplateControl("txtSType") as ASPxComboBox;
ASPxComboBox uSArea = ASPxGridView1.FindEditFormTemplateControl("txtSArea") as ASPxComboBox;
ASPxTextBox uSSeq = ASPxGridView1.FindEditFormTemplateControl("txtSSeq") as ASPxTextBox;
ASPxTextBox uSRemark = ASPxGridView1.FindEditFormTemplateControl("txtSRemark") as ASPxTextBox;
string strPCode = uPCode.Value.ToString();
string strSCode = uSCode.Text.Trim();
string strSName = uSName.Text.Trim().ToUpper();
string strSType = uSType.Value.ToString();
string strSArea = uSArea.Value.ToString();
string strSSeq = uSSeq.Text.Trim();
string strSRemark = uSRemark.Text.Trim();
string NstrSEQ = e.NewValues["STATION_SEQ"].ToString().Trim();
string OstrSEQ = e.OldValues["STATION_SEQ"].ToString().Trim();
int Nseq = Convert.ToInt32(NstrSEQ);
int Oseq = Convert.ToInt32(OstrSEQ);
if (Nseq > Oseq)
{
string UpSql = "UPDATE CODE_STATION SET STATION_SEQ = STATION_SEQ-1 WHERE COMPANY_CODE = '" + theCompanyCode + "'and STATION_SEQ <= '" + NstrSEQ + "' and STATION_SEQ >'" + OstrSEQ + "'AND PLINE_CODE='" + strPCode + "' ";
dc.ExeSql(UpSql);
e.Cancel = true;
}
else if (Nseq < Oseq)
{
string UpSql = "UPDATE CODE_STATION SET STATION_SEQ = STATION_SEQ+1 WHERE COMPANY_CODE = '" + theCompanyCode + "'and STATION_SEQ >= '" + NstrSEQ + "' and STATION_SEQ <'" + OstrSEQ + "'AND PLINE_CODE='" + strPCode + "' ";
dc.ExeSql(UpSql);
e.Cancel = true;
}
string Sql = "UPDATE CODE_STATION SET PLINE_CODE='" + strPCode + "',STATION_CODE='" + strSCode + "',STATION_NAME='" + strSName + "',STATION_TYPE='" + strSType + "',STATION_AREA='" + strSArea + "',"
+ "STATION_SEQ='" + strSSeq + "',STATION_REMARK='" + strSRemark + "' WHERE COMPANY_CODE = '" + theCompanyCode + "' and STATION_CODE = '" + strSCode + "'";
dc.ExeSql(Sql);
e.Cancel = true;
ASPxGridView1.CancelEdit();
setCondition();
}
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
if (!ASPxGridView1.IsNewRowEditing && ASPxGridView1.IsEditing)
{
///主键不可以修改
(ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox).Enabled = false;
}
else
{
//uTcode.SelectedIndex = 0;
}
}
protected void ASPxGridView1_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e)
{
ASPxTextEdit editor = (ASPxTextEdit)ASPxGridView1.FindEditFormTemplateControl("ASPxTextBox1");
// EditForm is open for editing
if (Request.Params[editor.UniqueID] == null)
{
editor.Text = DateTime.Now.ToLongTimeString();
}
// else
// the EditForm is recreated before the Update command is processed.
}
protected void ASPxGridView1_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
{
//判断超长
//string aa = e.NewValues["STATION_SPECIAL_CODE"].ToString();
//string bb = e.NewValues["STATION_SPECIAL_NAME"].ToString();
//string cc = e.NewValues["PLINE_CODE"].ToString();
ASPxComboBox PlineCode = ASPxGridView1.FindEditFormTemplateControl("PlineCombo") as ASPxComboBox;
if (e.NewValues["STATION_SPECIAL_CODE"].ToString().Length > 30)
{
e.RowError = "特殊站点代码字节长度不能超过30！";
}
if (e.NewValues["STATION_SPECIAL_NAME"].ToString().Length > 30)
{
e.RowError = "特殊站点名称字节长度不能超过30！";
}
//判断为空
if (e.NewValues["STATION_SPECIAL_CODE"].ToString() == "" || e.NewValues["STATION_SPECIAL_CODE"].ToString() == null)
{
e.RowError = "特殊站点代码不能为空！";
}
if (e.NewValues["STATION_SPECIAL_NAME"].ToString() == "" || e.NewValues["STATION_SPECIAL_NAME"].ToString() == null)
{
e.RowError = "特殊站点名称不能为空！";
}
//新增判断键值重复
if (ASPxGridView1.IsNewRowEditing)
{
string chSql = "SELECT COMPANY_CODE, STATION_SPECIAL_CODE, STATION_SPECIAL_NAME, STATION_CODE," +
"PLINE_CODE FROM CODE_STATION_SPECIAL"
+ " WHERE COMPANY_CODE = '" + companyCode + "' and STATION_SPECIAL_CODE='" + e.NewValues["STATION_SPECIAL_CODE"].ToString() + "'" +
" and PLINE_CODE='" + PlineCode.Value.ToString() + "'";
dataConn dc = new dataConn(chSql);
if (dc.GetState() == true)
{
e.RowError = "已存在相同的特殊站点代码，请确认后重新输入！";
}
}
FillStationCodeCombo(PlineCode.Value.ToString());
}
protected void SaveAndUpdate()
{
try
{
ASPxTextBox txt_Id = ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
string Id = SafeValue.SafeString(txt_Id.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(HrRecruitment), "Id='" + Id + "'");
HrRecruitment recruit = C2.Manager.ORManager.GetObject(query) as HrRecruitment;
bool action = false;
if (recruit == null)
{
action = true;
recruit = new HrRecruitment();
}
ASPxComboBox department = ASPxGridView1.FindEditFormTemplateControl("cmb_Department") as ASPxComboBox;
recruit.Department = department.Text;
ASPxTextBox recruitPic = ASPxGridView1.FindEditFormTemplateControl("txt_RecruitPic") as ASPxTextBox;
recruit.Pic = recruitPic.Text;
ASPxDateEdit recruitDay = ASPxGridView1.FindEditFormTemplateControl("date_RecruitDay") as ASPxDateEdit;
recruit.Date = recruitDay.Date;
ASPxMemo remark1 = ASPxGridView1.FindEditFormTemplateControl("memo_RecruitWork") as ASPxMemo;
recruit.Remark1 = remark1.Text;
ASPxMemo remark2 = ASPxGridView1.FindEditFormTemplateControl("memo_RecruitSalary") as ASPxMemo;
recruit.Remark2 = remark2.Text;
ASPxComboBox status = ASPxGridView1.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox;
recruit.StatusCode = status.Text;
if (action)
{
recruit.CreateBy = HttpContext.Current.User.Identity.Name;
recruit.CreateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(recruit, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(recruit);
}
else
{
recruit.UpdateBy = HttpContext.Current.User.Identity.Name;
recruit.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(recruit, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(recruit);
}
Session["Recruitment"] = "Id='" + recruit.Id + "'";
this.dsRecruitment.FilterExpression = Session["Recruitment"].ToString();
if (this.ASPxGridView1.GetRow(0) != null)
{
this.ASPxGridView1.StartEdit(0);
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void SaveAndUpdate()
{
try
{
ASPxTextBox txt_Id = ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox;
string Id = SafeValue.SafeString(txt_Id.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(HrInterview), "Id='" + Id + "'");
HrInterview itv = C2.Manager.ORManager.GetObject(query) as HrInterview;
bool action = false;
if (itv == null)
{
action = true;
itv = new HrInterview();
}
ASPxComboBox department = ASPxGridView1.FindEditFormTemplateControl("cmb_Department") as ASPxComboBox;
itv.Department = department.Text;
ASPxTextBox interviewPic = ASPxGridView1.FindEditFormTemplateControl("txt_InterviewPic") as ASPxTextBox;
itv.Pic = interviewPic.Text;
ASPxDateEdit interviewDay = ASPxGridView1.FindEditFormTemplateControl("date_InterviewDay") as ASPxDateEdit;
itv.Date = interviewDay.Date;
ASPxMemo remark = ASPxGridView1.FindEditFormTemplateControl("memo_InterviewRemark") as ASPxMemo;
itv.Remark = remark.Text;
ASPxMemo remark1 = ASPxGridView1.FindEditFormTemplateControl("memo_InterviewJoiner") as ASPxMemo;
itv.Remark1 = remark1.Text;
ASPxComboBox status = ASPxGridView1.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox;
itv.StatusCode = status.Text;
if (action)
{
itv.CreateBy = HttpContext.Current.User.Identity.Name;
itv.CreateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(itv, Wilson.ORMapper.InitialState.Inserted);
Manager.ORManager.PersistChanges(itv);
}
else
{
itv.UpdateBy = HttpContext.Current.User.Identity.Name;
itv.UpdateDateTime = DateTime.Now;
Manager.ORManager.StartTracking(itv, Wilson.ORMapper.InitialState.Updated);
Manager.ORManager.PersistChanges(itv);
}
Session["Interview"] = "Id='" + itv.Id + "'";
this.dsInterview.FilterExpression = Session["Interview"].ToString();
if (this.ASPxGridView1.GetRow(0) != null)
{
this.ASPxGridView1.StartEdit(0);
}
}
catch (Exception ex) { throw new Exception(ex.Message); }
}
protected void comboLocation_Callback(object sender, CallbackEventArgsBase e)
{
string pline = e.Parameter;
string Sql3 = " select location_code from ms_location_time where gzdd='" + pline + "' order by location_seq";//
DataTable dt3 = dc.GetTable(Sql3);
ASPxComboBox lCode = ASPxGridView1.FindEditFormTemplateControl("comboLocation") as ASPxComboBox;
lCode.DataSource = dt3;
lCode.TextField = dt3.Columns[0].ToString();
lCode.ValueField = dt3.Columns[0].ToString();
lCode.DataBind();
}
