Esempio n. 1
0
        public int Update(OAFileDestroy model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("update OA_File_Destroy set");
            builder.Append(" where DestroyRecordID=" + model.DestroyRecordID);
            return(publicDbOpClass.ExecSqlString(builder.ToString()));
        }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        this.Session["FILEDESTROY"] = this.GetSession();
        OAFileDestroy value     = this.AddOneDestroyRecord();
        ArrayList     arrayList = (ArrayList)this.Session["FILEDESTROY"];

        arrayList.Add(value);
        this.GVBook.DataSource = arrayList;
        this.GVBook.DataBind();
        this.Session["FILEDESTROY"] = arrayList;
    }
Esempio n. 3
0
        public int Add(OAFileDestroy model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("insert into OA_File_Destroy(");
            builder.Append("DestroyRecordID,DestroyFileID");
            builder.Append(")");
            builder.Append(" values (");
            builder.Append("'" + model.DestroyRecordID + "',");
            builder.Append(model.DestroyFileID);
            builder.Append(")");
            return(publicDbOpClass.ExecSqlString(builder.ToString()));
        }
    protected void GVBook_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowIndex > -1)
        {
            OAFileDestroy oAFileDestroy = (OAFileDestroy)e.Row.DataItem;
            e.Row.Attributes["onmouseover"] = "OnMouseOverRecord(this);";
            e.Row.Attributes["onclick"]     = string.Concat(new object[]
            {
                "OnRecord(this);ClickRow('",
                oAFileDestroy.DestroyFileID,
                "','",
                Convert.ToString(e.Row.RowIndex + 1),
                "');"
            });
            e.Row.Cells[0].Text = Convert.ToString(e.Row.RowIndex + 1);
            HtmlInputText htmlInputText = (HtmlInputText)e.Row.Cells[1].FindControl("txtFileName");
            htmlInputText.Value = oAFileDestroy.OAFileCatalog.FileName;
            htmlInputText.Attributes["ondblclick"] = "javascript:SelectFileName(this,'" + this.LibraryCode + "');";
            HtmlInputHidden htmlInputHidden = (HtmlInputHidden)e.Row.Cells[1].FindControl("HdnRecordID");
            htmlInputHidden.Value = oAFileDestroy.DestroyFileID.ToString();
            HtmlInputText htmlInputText2 = (HtmlInputText)e.Row.Cells[2].FindControl("txtFileCode");
            htmlInputText2.Value = oAFileDestroy.OAFileCatalog.FileCode;
            HtmlInputText htmlInputText3 = (HtmlInputText)e.Row.Cells[3].FindControl("txtPrjName");
            htmlInputText3.Value = oAFileDestroy.OAFileCatalog.PrjName;
            HtmlInputText htmlInputText4 = (HtmlInputText)e.Row.Cells[4].FindControl("txtSecretLevel");
            switch (oAFileDestroy.OAFileCatalog.SecretLevel)
            {
            case 1:
                htmlInputText4.Value = "密秘";
                return;

            case 2:
                htmlInputText4.Value = "机密";
                return;

            case 3:
                htmlInputText4.Value = "绝密";
                break;

            default:
                return;
            }
        }
    }
    private ArrayList GetSession()
    {
        ArrayList arrayList = new ArrayList();

        foreach (GridViewRow gridViewRow in this.GVBook.Rows)
        {
            OAFileDestroy   oAFileDestroy   = new OAFileDestroy();
            HtmlInputHidden htmlInputHidden = (HtmlInputHidden)gridViewRow.Cells[1].FindControl("HdnRecordID");
            oAFileDestroy.DestroyFileID = ((htmlInputHidden.Value.Trim() == "") ? -2 : int.Parse(htmlInputHidden.Value));
            HtmlInputText htmlInputText = (HtmlInputText)gridViewRow.Cells[1].FindControl("txtFileName");
            oAFileDestroy.OAFileCatalog.FileName = htmlInputText.Value;
            HtmlInputText htmlInputText2 = (HtmlInputText)gridViewRow.Cells[2].FindControl("txtFileCode");
            oAFileDestroy.OAFileCatalog.FileCode = htmlInputText2.Value;
            HtmlInputText htmlInputText3 = (HtmlInputText)gridViewRow.Cells[2].FindControl("txtPrjName");
            oAFileDestroy.OAFileCatalog.PrjName = htmlInputText3.Value;
            HtmlInputText htmlInputText4 = (HtmlInputText)gridViewRow.Cells[2].FindControl("txtSecretLevel");
            oAFileDestroy.OAFileCatalog.SecretLevel = ((htmlInputText4.Value.Trim() == "密秘") ? 1 : ((htmlInputText4.Value.Trim() == "机密") ? 2 : ((htmlInputText4.Value.Trim() == "绝密") ? 3 : 0)));
            oAFileDestroy.DestroyRecordID           = this.RecordCode;
            arrayList.Add(oAFileDestroy);
        }
        return(arrayList);
    }
Esempio n. 6
0
        public ArrayList GetModel(string strWhere)
        {
            ArrayList     list    = new ArrayList();
            StringBuilder builder = new StringBuilder();

            builder.Append("select * FROM V_OA_File_Destroy ");
            if (strWhere.Trim() != "")
            {
                builder.Append(" where " + strWhere);
            }
            DataTable table = publicDbOpClass.DataTableQuary(builder.ToString());

            if (table.Rows.Count > 0)
            {
                for (int i = 0; i < table.Rows.Count; i++)
                {
                    OAFileDestroy destroy = new OAFileDestroy();
                    if (table.Rows[i]["DestroyRecordID"].ToString() != "")
                    {
                        destroy.DestroyRecordID = new Guid(table.Rows[i]["DestroyRecordID"].ToString());
                    }
                    if (table.Rows[i]["DestroyFileID"].ToString() != "")
                    {
                        destroy.DestroyFileID = int.Parse(table.Rows[i]["DestroyFileID"].ToString());
                    }
                    destroy.OAFileCatalog.FileName = table.Rows[i]["FileName"].ToString();
                    destroy.OAFileCatalog.FileCode = table.Rows[i]["FileCode"].ToString();
                    destroy.OAFileCatalog.PrjName  = table.Rows[i]["PrjName"].ToString();
                    if (table.Rows[i]["SecretLevel"].ToString() != "")
                    {
                        destroy.OAFileCatalog.SecretLevel = int.Parse(table.Rows[i]["SecretLevel"].ToString());
                    }
                    list.Add(destroy);
                }
            }
            return(list);
        }