protected void ASPxGridView1_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e) { //删除 //调用存储过程进行处理 MW_MODIFY_USER_PROGRAM sp = new MW_MODIFY_USER_PROGRAM() { THEFUNCTION1 = "DELETE", THECOMPANYCODE1 = theCompanyCode, THEUSERID1 = e.Keys["USER_ID"].ToString(), THEPROGRAMCODE1 = e.Values["PROGRAM_CODE"].ToString(), THEPLINECODE1 = e.Values["PLINE_CODE"].ToString() }; Procedure.run(sp); setCondition(); e.Cancel = true; }
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { //新增 int indexProgram, indexUser, indexPline; ASPxGridLookup gridLookupProgram = ASPxGridView1.FindEditFormTemplateControl("GridLookupProgram") as ASPxGridLookup; ASPxGridLookup gridLookupUser = ASPxGridView1.FindEditFormTemplateControl("GridLookupUser") as ASPxGridLookup; ASPxGridLookup gridLookupPline = ASPxGridView1.FindEditFormTemplateControl("GridLookupPline") as ASPxGridLookup; List <object> Programs = gridLookupProgram.GridView.GetSelectedFieldValues("PROGRAM_CODE"); List <object> Users = gridLookupUser.GridView.GetSelectedFieldValues("USER_ID"); List <object> Plines = gridLookupPline.GridView.GetSelectedFieldValues("PLINE_CODE"); for (indexProgram = 0; indexProgram < Programs.Count; indexProgram++) { for (indexUser = 0; indexUser < Users.Count; indexUser++) { //调用存储过程进行处理 for (indexPline = 0; indexPline < Plines.Count; indexPline++) { MW_MODIFY_USER_PROGRAM sp = new MW_MODIFY_USER_PROGRAM() { THEFUNCTION1 = "ADD", THECOMPANYCODE1 = theCompanyCode, THEUSERID1 = Users[indexUser].ToString(), THEPROGRAMCODE1 = Programs[indexProgram].ToString(), THEPLINECODE1 = Plines[indexPline].ToString() }; Procedure.run(sp); } } } setCondition(); e.Cancel = true; ASPxGridView1.CancelEdit(); }