public MainSys(string name) : this()
{
this.name = name;
string qry = "select * from susermod where usercode ='" + this.name + "'";
MdPubFunc funcs = new MdPubFunc();
DataSet ds = new DataSet();
ds = funcs.getDataSet(qry, MdDefine.strcon);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ToolStripMenuItem AmenuItem = new ToolStripMenuItem();
AmenuItem.Name = ds.Tables[0].Rows[i][1].ToString();
AmenuItem.Text = ds.Tables[0].Rows[i][1].ToString();
MenuStrip.Items.Add(AmenuItem);
addSubMenu(ds.Tables[0].Rows[i][1].ToString(), AmenuItem);
}
// Language Menu
ToolStripMenuItem LangpmenuItem = new ToolStripMenuItem();
LangpmenuItem.Name = "Language";
LangpmenuItem.Text = "Language";
MenuStrip.Items.Add(LangpmenuItem);
string qry1 = "select sLangName from sLang";
ds = funcs.getDataSet(qry1, MdDefine.strcon);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ToolStripMenuItem AmenuItem = new ToolStripMenuItem();
AmenuItem.Name = ds.Tables[0].Rows[i][0].ToString();
AmenuItem.Text = ds.Tables[0].Rows[i][0].ToString();
AmenuItem.Click += ShowSubForm;
LangpmenuItem.DropDownItems.Add(AmenuItem);
}
// Help Menu
ToolStripMenuItem HelpmenuItem = new ToolStripMenuItem();
HelpmenuItem.Name = "Help";
HelpmenuItem.Text = "Help";
MenuStrip.Items.Add(HelpmenuItem);
ToolStripMenuItem childpmenuItem = new ToolStripMenuItem();
// string FilePath = @"Images\infor.bmp";
childpmenuItem.Name = "About";
childpmenuItem.Text = "About";
childpmenuItem.ShortcutKeys = Keys.Control | Keys.I;
// childpmenuItem.Image = Image.FromFile(FilePath);
childpmenuItem.Click += ShowSubForm;
HelpmenuItem.DropDownItems.Add(childpmenuItem);
}
private void bt_inq_Click(object sender, EventArgs e)
{
//string query = "select * from sUser";
string query = "exec USP_GetAllUser";
MdPubFunc funcs = new MdPubFunc();
DataSet ds = new DataSet();
ds = funcs.getDataSet(query, MdDefine.strcon);
gridview_user.DataSource = ds.Tables[0];
}
private void addSubMenu(string modname, ToolStripMenuItem PMenu)
{
string qry = "select CONCAT_WS (' ',sFormId ,sFormName) as info from sForm where sFormsModuleId = '" + modname + "'";
//string qry = "select * from sform where moduleid = '" + modname + "'";
MdPubFunc funcs = new MdPubFunc();
//MySqlDataReader reader;
DataSet ds = new DataSet();
ds = funcs.getDataSet(qry, MdDefine.strcon);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ToolStripMenuItem AmenuItem = new ToolStripMenuItem();
AmenuItem.Name = ds.Tables[0].Rows[i][0].ToString();
AmenuItem.Text = ds.Tables[0].Rows[i][0].ToString();
AmenuItem.Click += ShowSubForm;
PMenu.DropDownItems.Add(AmenuItem);
}
//if (reader.HasRows)
//{
// try
// {
// while (reader.Read())
// {
// ToolStripMenuItem AmenuItem = new ToolStripMenuItem();
// AmenuItem.Name = reader["formid"].ToString();
// AmenuItem.Text = reader["formid"].ToString();
// AmenuItem.Click += ShowSubForm;
// PMenu.DropDownItems.Add(AmenuItem);
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.ToString());
// Close();
// }
// finally
// {
// reader.Close();
// }
//}
}