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();
}
