Beispiel #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Model.RECEIVINGLOG model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into RECEIVINGLOG(");
            strSql.Append("PID,ISSUEDATE,RECEIVED,RECEIVEDBY,SENDERID,SENDER,OURNO,APPNO,CLIENTNO,CONTENT,COPIES,PAGES,HANDLER,COMMENTS,STATUS)");
            strSql.Append(" values (");
            strSql.Append(":PID,:ISSUEDATE,:RECEIVED,:RECEIVEDBY,:SENDERID,:SENDER,:OURNO,:APPNO,:CLIENTNO,:CONTENT,:COPIES,:PAGES,:HANDLER,:COMMENTS,:STATUS)");
            OracleParameter[] parameters =
            {
                new OracleParameter(":PID",        OracleType.VarChar,    30),
                new OracleParameter(":ISSUEDATE",  OracleType.DateTime),
                new OracleParameter(":RECEIVED",   OracleType.DateTime),
                new OracleParameter(":RECEIVEDBY", OracleType.VarChar,    10),
                new OracleParameter(":SENDERID",   OracleType.Char,        4),
                new OracleParameter(":SENDER",     OracleType.VarChar,   100),
                new OracleParameter(":OURNO",      OracleType.VarChar,    20),
                new OracleParameter(":APPNO",      OracleType.VarChar,    40),
                new OracleParameter(":CLIENTNO",   OracleType.VarChar,    40),
                new OracleParameter(":CONTENT",    OracleType.VarChar,    40),
                new OracleParameter(":COPIES",     OracleType.Number,      2),
                new OracleParameter(":PAGES",      OracleType.Number,      3),
                new OracleParameter(":HANDLER",    OracleType.VarChar,    10),
                new OracleParameter(":COMMENTS",   OracleType.VarChar,   100),
                new OracleParameter(":STATUS",     OracleType.VarChar, 5)
            };
            parameters[0].Value  = model.PID;
            parameters[1].Value  = model.ISSUEDATE;
            parameters[2].Value  = model.RECEIVED;
            parameters[3].Value  = model.RECEIVEDBY;
            parameters[4].Value  = model.SENDERID;
            parameters[5].Value  = model.SENDER;
            parameters[6].Value  = model.OURNO;
            parameters[7].Value  = model.APPNO;
            parameters[8].Value  = model.CLIENTNO;
            parameters[9].Value  = model.CONTENT;
            parameters[10].Value = model.COPIES;
            parameters[11].Value = model.PAGES;
            parameters[12].Value = model.HANDLER;
            parameters[13].Value = model.COMMENTS;
            parameters[14].Value = model.STATUS;

            int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Beispiel #2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Model.RECEIVINGLOG GetModel(string PID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select PID,ISSUEDATE,RECEIVED,RECEIVEDBY,SENDERID,SENDER,OURNO,APPNO,CLIENTNO,CONTENT,COPIES,PAGES,HANDLER,COMMENTS,STATUS from RECEIVINGLOG ");
            strSql.Append(" where PID=:PID ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":PID", OracleType.VarChar, 30)
            };
            parameters[0].Value = PID;

            Model.RECEIVINGLOG model = new Model.RECEIVINGLOG();
            DataSet            ds    = DbHelperOra.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Beispiel #3
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Model.RECEIVINGLOG model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update RECEIVINGLOG set ");
            strSql.Append("PID=:PID,");
            strSql.Append("ISSUEDATE=:ISSUEDATE,");
            strSql.Append("RECEIVED=:RECEIVED,");
            strSql.Append("RECEIVEDBY=:RECEIVEDBY,");
            strSql.Append("SENDERID=:SENDERID,");
            strSql.Append("SENDER=:SENDER,");
            strSql.Append("OURNO=:OURNO,");
            strSql.Append("APPNO=:APPNO,");
            strSql.Append("CLIENTNO=:CLIENTNO,");
            strSql.Append("CONTENT=:CONTENT,");
            strSql.Append("COPIES=:COPIES,");
            strSql.Append("PAGES=:PAGES,");
            strSql.Append("HANDLER=:HANDLER,");
            strSql.Append("COMMENTS=:COMMENTS,");
            strSql.Append("STATUS=:STATUS");
            strSql.Append(" where PID=:PID ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":PID",        OracleType.VarChar,    30),
                new OracleParameter(":ISSUEDATE",  OracleType.DateTime),
                new OracleParameter(":RECEIVED",   OracleType.DateTime),
                new OracleParameter(":RECEIVEDBY", OracleType.VarChar,    10),
                new OracleParameter(":SENDERID",   OracleType.Char,        4),
                new OracleParameter(":SENDER",     OracleType.VarChar,   100),
                new OracleParameter(":OURNO",      OracleType.VarChar,    20),
                new OracleParameter(":APPNO",      OracleType.VarChar,    40),
                new OracleParameter(":CLIENTNO",   OracleType.VarChar,    40),
                new OracleParameter(":CONTENT",    OracleType.VarChar,    40),
                new OracleParameter(":COPIES",     OracleType.Number,      2),
                new OracleParameter(":PAGES",      OracleType.Number,      3),
                new OracleParameter(":HANDLER",    OracleType.VarChar,    10),
                new OracleParameter(":COMMENTS",   OracleType.VarChar,   100),
                new OracleParameter(":STATUS",     OracleType.VarChar, 5)
            };
            parameters[0].Value  = model.PID;
            parameters[1].Value  = model.ISSUEDATE;
            parameters[2].Value  = model.RECEIVED;
            parameters[3].Value  = model.RECEIVEDBY;
            parameters[4].Value  = model.SENDERID;
            parameters[5].Value  = model.SENDER;
            parameters[6].Value  = model.OURNO;
            parameters[7].Value  = model.APPNO;
            parameters[8].Value  = model.CLIENTNO;
            parameters[9].Value  = model.CONTENT;
            parameters[10].Value = model.COPIES;
            parameters[11].Value = model.PAGES;
            parameters[12].Value = model.HANDLER;
            parameters[13].Value = model.COMMENTS;
            parameters[14].Value = model.STATUS;

            int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Beispiel #4
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Model.RECEIVINGLOG DataRowToModel(DataRow row)
 {
     Model.RECEIVINGLOG model = new Model.RECEIVINGLOG();
     if (row != null)
     {
         if (row["PID"] != null)
         {
             model.PID = row["PID"].ToString();
         }
         if (row["ISSUEDATE"] != null && row["ISSUEDATE"].ToString() != "")
         {
             model.ISSUEDATE = DateTime.Parse(row["ISSUEDATE"].ToString());
         }
         if (row["RECEIVED"] != null && row["RECEIVED"].ToString() != "")
         {
             model.RECEIVED = DateTime.Parse(row["RECEIVED"].ToString());
         }
         if (row["RECEIVEDBY"] != null)
         {
             model.RECEIVEDBY = row["RECEIVEDBY"].ToString();
         }
         if (row["SENDERID"] != null)
         {
             model.SENDERID = row["SENDERID"].ToString();
         }
         if (row["SENDER"] != null)
         {
             model.SENDER = row["SENDER"].ToString();
         }
         if (row["OURNO"] != null)
         {
             model.OURNO = row["OURNO"].ToString();
         }
         if (row["APPNO"] != null)
         {
             model.APPNO = row["APPNO"].ToString();
         }
         if (row["CLIENTNO"] != null)
         {
             model.CLIENTNO = row["CLIENTNO"].ToString();
         }
         if (row["CONTENT"] != null)
         {
             model.CONTENT = row["CONTENT"].ToString();
         }
         if (row["COPIES"] != null && row["COPIES"].ToString() != "")
         {
             model.COPIES = decimal.Parse(row["COPIES"].ToString());
         }
         if (row["PAGES"] != null && row["PAGES"].ToString() != "")
         {
             model.PAGES = decimal.Parse(row["PAGES"].ToString());
         }
         if (row["HANDLER"] != null)
         {
             model.HANDLER = row["HANDLER"].ToString();
         }
         if (row["COMMENTS"] != null)
         {
             model.COMMENTS = row["COMMENTS"].ToString();
         }
         if (row["STATUS"] != null)
         {
             model.STATUS = row["STATUS"].ToString();
         }
     }
     return(model);
 }
Beispiel #5
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Model.RECEIVINGLOG model)
 {
     return(dal.Update(model));
 }
Beispiel #6
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(Model.RECEIVINGLOG model)
 {
     return(dal.Add(model));
 }