protected void ImportFromExcelToCreate(DataSet ds)
{
try
{
System.Data.DataTable dt = ds.Tables[0];
int nAll = dt.Rows.Count;
int nCreate = 0;
foreach (System.Data.DataRow dr in dt.Rows)
{
if (dr["SelectX"].ToString().ToLower() == "x")
{
string menuid = Guid.NewGuid().ToString();
string menuparentid = lbl_MenuID.Text.Trim();
//string menucode = tbx_MenuCode.Text.Trim();
string menuname = dr["MenuName"].ToString().Trim();
string menudesc = dr["MenuDesc"].ToString().Trim();
int menuisdisplay = int.Parse(dr["MenuIsDisplay"].ToString().Trim());
int menuindex = int.Parse(dr["MenuIndex"].ToString().Trim());
int menutype = int.Parse(dr["MenuType"].ToString().Trim());
string menuurl = dr["MenuURL"].ToString().Trim();
string menugif = dr["MenuGIF"].ToString().Trim();
int menutarget = int.Parse(dr["MenuTarget"].ToString().Trim());
string menugroups = "AA,";
int menuisvalid = int.Parse(dr["MenuIsValid"].ToString().Trim());
string menunote = dr["MenuNote"].ToString().Trim();
string menucreatetime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
string menumodifytime = menucreatetime;
KPI_MenuEntity sysMenu = new KPI_MenuEntity();
sysMenu.MenuID = menuid;
sysMenu.MenuParentID = menuparentid;
//sysMenu.MenuCode = menucode;
sysMenu.MenuName = menuname;
sysMenu.MenuDesc = menudesc;
sysMenu.MenuIsDisplay = menuisdisplay;
sysMenu.MenuIndex = menuindex;
sysMenu.MenuType = menutype;
sysMenu.MenuURL = menuurl;
sysMenu.MenuGIF = menugif;
sysMenu.MenuTarget = menutarget;
sysMenu.MenuGroups = menugroups;
sysMenu.MenuIsValid = menuisvalid;
sysMenu.MenuNote = menunote;
sysMenu.MenuCreateTime = menucreatetime;
sysMenu.MenuModifyTime = menumodifytime;
if (KPI_MenuDal.Insert(sysMenu))
{
nCreate += 1;
}
}
}
string strInfor = "菜单总数：{0}个, 创建成功：{1}个。";
strInfor = string.Format(strInfor, nAll, nCreate);
MessageBox.popupClientMessage(this.Page, strInfor, "call();");
BindGrid();
return;
}
catch (Exception)
{
//
//MessageBox.popupClientMessage(this.Page, ee.Message, "call();");
return;
}
}
/// <summary>
/// 添加新的节点到菜单集合
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnMenuAdd_Click(object sender, EventArgs e)
{
//protected String _MenuID = null;
//protected String _MenuParentID = null;
//protected String _MenuCode = null;
//protected String _MenuName = null;
//protected String _MenuDesc = null;
//protected int _MenuIsDisplay = int.MinValue;
//protected int _MenuType = int.MinValue;
//protected String _MenuURL = null;
//protected String _MenuGIF = null;
//protected int _MenuTarget = int.MinValue;
//protected String _MenuGroups = null;
//protected int _MenuIsValid = int.MinValue;
//protected String _MenuNote = null;
//protected String _MenuCreateTime = null;
//protected String _MenuModifyTime = null;
//strGroupCollections= GetGroupSelected(dtGroups);
//lbl_MenuGroups.Text = strGroupCollections;
string menuid = ""; // lbl_MenuID.Text.Trim();
string menuparentid = ddl_MenuParentID.Value;
string menucode = tbx_MenuCode.Text.Trim();
string menuname = tbx_MenuName.Text.Trim();
string menudesc = tbx_MenuDesc.Text.Trim();
int menuisdisplay = int.Parse(rbl_MenuIsDisplay.SelectedValue);
int menuindex = 0;
int menutype = int.Parse(rbl_MenuType.SelectedValue);
string menuurl = tbx_MenuURL.Text.Trim();
string menugif = tbx_MenuGIF.Text.Trim();
int menutarget = int.Parse(rbl_MenuTarget.SelectedValue);
string menugroups = "AA,";
int menuisvalid = int.Parse(rbl_MenuIsValid.SelectedValue);
string menunote = tbx_MenuNote.Text.Trim();
string menucreatetime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss");
string menumodifytime = menucreatetime;
if (menuid == "")
{
menuid = Guid.NewGuid().ToString();
}
KPI_MenuEntity sysMenu = new KPI_MenuEntity();
sysMenu.MenuID = menuid;
sysMenu.MenuParentID = menuparentid;
sysMenu.MenuCode = menucode;
sysMenu.MenuName = menuname;
sysMenu.MenuDesc = menudesc;
sysMenu.MenuIsDisplay = menuisdisplay;
sysMenu.MenuIndex = menuindex;
sysMenu.MenuType = menutype;
sysMenu.MenuURL = menuurl;
sysMenu.MenuGIF = menugif;
sysMenu.MenuTarget = menutarget;
sysMenu.MenuGroups = menugroups;
sysMenu.MenuIsValid = menuisvalid;
sysMenu.MenuNote = menunote;
sysMenu.MenuCreateTime = menucreatetime;
sysMenu.MenuModifyTime = menumodifytime;
if (KPI_MenuDal.Insert(sysMenu))
{
MessageBox.popupClientMessage(this.Page, "添加成功！", "call();");
}
else
{
MessageBox.popupClientMessage(this.Page, "添加错误！", "call();");
}
BindGrid();
}
