C# Organization_mst类代码示例

 protected void Orggrdvw_RowDeleting(object sender, GridViewDeleteEventArgs e)
 {
     int orgid=0;
     Organization_mst orgobj = new Organization_mst();
     orgid = Convert.ToInt16(Orggrdvw.Rows[e.RowIndex].Cells[0].Text);
     orgobj.Delete(orgid);
     BindGrid();
     lblErrorMsg.Text = Resources.MessageResource.errdelete.ToString();
 }

 public void BindGrid()
 {
     BLLCollection<Organization_mst> col = new BLLCollection<Organization_mst>();
     Organization_mst orgobj = new Organization_mst();
     col = orgobj.Get_All();
     Orggrdvw.DataSource = col;
     Orggrdvw.DataBind();
     clearControl();
 }

    public object GenerateOrganization_mstObject(ref IDataReader returnData)
    {
        Organization_mst obj = new Organization_mst();
        while (returnData.Read())
        {
            DateTime Mydatetime = new DateTime();
            obj.Orgid = (int)returnData["Orgid"];
            obj.Orgname = (string)returnData["Orgname"];
            obj.Description = (string)returnData["Description"];
            Mydatetime = (DateTime)returnData["Createdatetime"];
            obj.Createdatetime = Mydatetime.ToString();

        }
        returnData.Close();
        returnData.Dispose();
        return obj;
    }

    public CollectionBase GenerateOrganization_mstCollection(ref IDataReader returnData)
    {
        BLLCollection<Organization_mst> col = new BLLCollection<Organization_mst>();
        while (returnData.Read())
        {
            DateTime Mydatetime = new DateTime();

            Organization_mst obj = new Organization_mst();
            obj.Orgid = (int)returnData["Orgid"];
            obj.Orgname = (string)returnData["Orgname"];
            obj.Description = (string)returnData["Description"];
            Mydatetime = (DateTime)returnData["Createdatetime"];
            obj.Createdatetime = Mydatetime.ToString();
            col.Add(obj);
        }
        returnData.Close();
        returnData.Dispose();
        return col;
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        ///Add Exception handilng try catch change by vishal 21-05-2012
        try
        {
            #region Get Current User and his Role
            MembershipUser User = Membership.GetUser();
            objOrganization = objOrganization.Get_Organization();
            int userid = objUser.Get_By_UserName(User.UserName.ToString(), objOrganization.Orgid);
            if (userid != 0)
            {
                objContact = objContact.Get_By_id(userid);
                lblUser.Text = objContact.Firstname + "  " + objContact.Lastname;

            }

        }
        catch (Exception ex)
        {
            string myScript;
            myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);
            return;
        }
            #endregion
    }

    protected void btnadd_Click(object sender, EventArgs e)
    {
        /////Add Exception handilng try catch change by vishal 21-05-2012
        try
        {
            #region Fetch Current User

            // Fetch Current User and assign to local variable userName
            MembershipUser User = Membership.GetUser();
            string userName = User.UserName.ToString();
            #endregion
            ObjOrganization = ObjOrganization.Get_Organization();
            int orgid = Convert.ToInt32(ObjOrganization.Orgid);
            int userid = ObjUser.Get_By_UserName(userName, orgid);
            ObjChangeNotes.Username = userid;
            ObjChangeNotes.Changeid = Convert.ToInt32(Request.QueryString[0]);
            ObjChangeNotes.Comments = txtcomments.Text.ToString();
            ObjChangeNotes.Insert();
            string myScript;
            myScript = "<script language=javascript>refreshParent();</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);

        }
        catch (Exception ex)
        {
            string myScript;
            myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);
            return;
        }
    }

    protected void btnSolutionAdd_Click(object sender, EventArgs e)
    {
        string userName;
        MembershipUser User = Membership.GetUser();
        userName = User.UserName.ToString();
        int userid;
        objOrganization = objOrganization.Get_Organization();
        objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid);

        int Solutionid;
        ObjSolution.Title = txtTitle.Text.ToString();
        ObjSolution.Content=Editor.Text.ToString();
        ObjSolution.Topicid = Convert.ToInt16(drpTopic.SelectedValue);
        ObjSolution.Solution = drpSolutionType.SelectedValue;
        ObjSolution.Insert();
        Solutionid = ObjSolutionKeyword.Get_SolutionId();
        ObjSolutionKeyword.Keywords=txtKeywords.Text.ToString();
        ObjSolutionKeyword.Solutionid = Solutionid;
        ObjSolutionKeyword.Insert();
        ObjSolutionCreator.Solutionid = Solutionid;
        ObjSolutionCreator.Createdby = objUser.Userid;
        ObjSolutionCreator.Insert();
        objSentMailToUser.SentMailToPManager(Solutionid);
        Response.Redirect("ViewSolution.aspx?solutionid" + Solutionid);
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        //Add Exception handilng try catch change by vishal 21-05-2012
        try
        {
            if (!IsPostBack)
            {
                MembershipUser User = Membership.GetUser();
                objOrganization = objOrganization.Get_Organization();
                int userid = objUser.Get_By_UserName(User.UserName.ToString(), objOrganization.Orgid);
                if (userid != 0)
                {
                    objContact = objContact.Get_By_id(userid);
                    lblUser.Text = objContact.Firstname + "  " + objContact.Lastname;
                }
            }
            XmlDataSource ds = new XmlDataSource();
            ds.EnableCaching = false;
            ds.DataFile = Server.MapPath("../Files/Admin.xml");
            TreeView1.DataSource = ds;
            TreeView1.DataBind();

        }
        catch (Exception ex)
        {
            string myScript;
            myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);
            return;
        }
    }

    public void updatecomment()
    {
        string userName;
        MembershipUser User = Membership.GetUser();

        solutionstatusid = Convert.ToInt32(Request.QueryString[0]);
        flag = Convert.ToInt32(Request.QueryString[1]);
        int userid;
        if (flag == 3)
        {
            string seeionsid = Session["SolutionId"].ToString();

            string[] str = seeionsid.Split(new char[] { ',' });
            foreach (string s in str)
            {
                if (s == "")
                {
                    break;
                }
                int solid = Convert.ToInt32(s);
                ObjSolution = ObjSolution.Get_By_id(solid);
                ObjSolution.Title = ObjSolution.Title;
                ObjSolution.Topicid = ObjSolution.Topicid;
                ObjSolution.Content = ObjSolution.Content;
                ObjSolution.Comments = txtcomments.Text;
                ObjSolution.SolutionStatus = solutionstatusid;
                ObjSolution.Update();

                userName = User.UserName.ToString();

                Objorganization = Objorganization.Get_Organization();
                objUser = objUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid);
                ObjSolutionCreator.Solutionid = solid;
                ObjSolutionCreator.LastUpdateBy = objUser.Userid;
                ObjSolutionCreator.Update();
            }
        }
        else
        {
            int solutionid = Convert.ToInt32(Request.QueryString[1]);

            ObjSolution = ObjSolution.Get_By_id(solutionid);
            ObjSolution.Title = ObjSolution.Title;
            ObjSolution.Topicid = ObjSolution.Topicid;
            ObjSolution.Content = ObjSolution.Content;
            ObjSolution.Comments = txtcomments.Text;
            ObjSolution.SolutionStatus = solutionstatusid;
            ObjSolution.Update();

            userName = User.UserName.ToString();

            Objorganization = Objorganization.Get_Organization();
            objUser = objUser.Get_UserLogin_By_UserName(userName, Objorganization.Orgid);
            ObjSolutionCreator.Solutionid = solutionid;
            ObjSolutionCreator.LastUpdateBy = objUser.Userid;
            ObjSolutionCreator.Update();
        }
    }

 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         reqValRegion.ErrorMessage = Resources.MessageResource.errRegionName.ToString();
         objOrganization = objOrganization.Get_Organization();
         BindGrid();
     }
 }

    protected void BindDropSite()
    {
        string userName = "";
        MembershipUser User = Membership.GetUser();
        if (User != null)
        {
            userName = User.UserName.ToString();
        }

        if (userName != "")
        {
            int userid;
            objOrganization = objOrganization.Get_Organization();
            objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid);
            if (objUser.Userid != 0)
            {
                userid = objUser.Userid;
                colUserToSite = ObjUserToSite.Get_All_By_userid(userid);
                foreach (UserToSiteMapping obj in colUserToSite)
                {
                    int siteid;
                    Site_mst objSite1 = new Site_mst();
                    siteid = obj.Siteid;
                    objSite1 = objSite1.Get_By_id(siteid);
                    if (objSite1.Siteid != 0)
                    {
                        colSite.Add(objSite1);
                    }

                }

            }
            drpSite.DataTextField = "sitename";
            drpSite.DataValueField = "siteid";
            drpSite.DataSource = colSite;
            drpSite.DataBind();
            ListItem item = new ListItem();
            item.Text = "-------------Select-------------";
            item.Value = "0";
            drpSite.Items.Add(item);
            drpSite.SelectedValue = "0";

            //drpSite1.DataTextField = "sitename";
            //drpSite1.DataValueField = "siteid";
            //drpSite1.DataSource = colSite;
            //drpSite1.DataBind();
            //ListItem item1= new ListItem();
            //item1.Text = "-------------Select-------------";
            //item1.Value = "0";
            //drpSite1.Items.Add(item1);
            //drpSite1.SelectedValue = "0";

        }
    }

    protected void btnapprove_Click(object sender, EventArgs e)
    {
        int userid=0;
        int incidentid = Convert.ToInt16(Session["incidentid"].ToString());
        if (incidentid != 0)
        {

            //objIncidentLog = objIncidentLog.Get_By_id(incidentid);
            //if (objIncidentLog.Incidentid != 0)
            //{
            //    objIncidentLog.Incidentid = incidentid;
            //    objIncidentLog.Incidentlog = txtcomments.Text;
            //    objIncidentLog.Update();

            //}
            //else
            //{
            //    objIncidentLog.Incidentid = incidentid;
            //    objIncidentLog.Incidentlog = txtcomments.Text;
            //    objIncidentLog.Insert();

            //}

        string userName="";
        MembershipUser User = Membership.GetUser();
        if (User != null)
        {
            userName = User.UserName.ToString();
        }

        if (userName != "")
        {

            objOrganization = objOrganization.Get_Organization();
            objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid);
            if (objUser.Userid != 0)
            {
                userid = objUser.Userid;
            }
        }

            objIncidentLog.Incidentid = incidentid;
            objIncidentLog.Userid = userid;
            objIncidentLog.Incidentlog = txtcomments.Text;
            objIncidentLog.Insert();

            string myScript;
            myScript = "<script language=javascript>javascript:refreshParent(); javascript:window.close();</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);

        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        #region Get Current User and his Role
        MembershipUser User = Membership.GetUser();
        objOrganization = objOrganization.Get_Organization();
        int userid = objUser.Get_By_UserName(User.UserName.ToString(), objOrganization.Orgid);
        if (userid != 0)
        {
            objContact = objContact.Get_By_id(userid);
            lblUser.Text = objContact.Firstname + "  " + objContact.Lastname;

        }

        #endregion
    }

    protected void btnapprove_Click(object sender, EventArgs e)
    {
        /////Add Exception handilng try catch change by vishal 21-05-2012
        try
        {
            int userid = 0;
            int incidentid = Convert.ToInt32(Session["incidentid"].ToString());
            if (incidentid != 0)
            {

                string userName = "";
                MembershipUser User = Membership.GetUser();
                if (User != null)
                {
                    userName = User.UserName.ToString();
                }

                if (userName != "")
                {

                    objOrganization = objOrganization.Get_Organization();
                    objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid);
                    if (objUser.Userid != 0)
                    {
                        userid = objUser.Userid;
                    }
                }

                objIncidentLog.Incidentid = incidentid;
                objIncidentLog.Userid = userid;
                objIncidentLog.Incidentlog = txtcomments.Text;
                objIncidentLog.Insert();

                string myScript;
                myScript = "<script language=javascript>javascript:window.close();</script>";
                Page.RegisterClientScriptBlock("MyScript", myScript);

            }
        }
        catch (Exception ex)
        {
            string myScript;
            myScript = "<script language=javascript>alert('Exception - '" + ex + "');</script>";
            Page.RegisterClientScriptBlock("MyScript", myScript);
            return;
        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            MembershipUser User = Membership.GetUser();
            objOrganization = objOrganization.Get_Organization();
            int userid = objUser.Get_By_UserName(User.UserName.ToString(), objOrganization.Orgid);
            if (userid != 0)
            {
                objContact = objContact.Get_By_id(userid);
                lblUser.Text = objContact.Firstname + "  " + objContact.Lastname;

            }

        }
    }