示例#1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Model.BILL GetModel(string NOTENUMBER)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select CASENO,NOTENUMBER,ISSUENUMBER,TYPE,ISSUED,PAID,STATUS,COMMENTS,ADDRESS,CLIENT,OWNER,CURRENCYID,ACCOUNTID,BILLING_START_DATE,BILLING_END_DATE,FIRMID,CLIENT_MATTERID,SIGS,DESCLINE from BILL ");
            strSql.Append(" where NOTENUMBER=:NOTENUMBER ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":NOTENUMBER", OracleType.VarChar, 23)
            };
            parameters[0].Value = NOTENUMBER;

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

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
示例#2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Model.BILL model)
 {
     return(dal.Update(model));
 }
示例#3
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public bool Add(Model.BILL model)
 {
     return(dal.Add(model));
 }
示例#4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Model.BILL model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into BILL(");
            strSql.Append("CASENO,NOTENUMBER,ISSUENUMBER,TYPE,ISSUED,PAID,STATUS,COMMENTS,ADDRESS,CLIENT,OWNER,CURRENCYID,ACCOUNTID,BILLING_START_DATE,BILLING_END_DATE,FIRMID,CLIENT_MATTERID,SIGS,DESCLINE)");
            strSql.Append(" values (");
            strSql.Append(":CASENO,:NOTENUMBER,:ISSUENUMBER,:TYPE,:ISSUED,:PAID,:STATUS,:COMMENTS,:ADDRESS,:CLIENT,:OWNER,:CURRENCYID,:ACCOUNTID,:BILLING_START_DATE,:BILLING_END_DATE,:FIRMID,:CLIENT_MATTERID,:SIGS,:DESCLINE)");
            OracleParameter[] parameters =
            {
                new OracleParameter(":CASENO",             OracleType.VarChar,    24),
                new OracleParameter(":NOTENUMBER",         OracleType.VarChar,    23),
                new OracleParameter(":ISSUENUMBER",        OracleType.VarChar,    20),
                new OracleParameter(":TYPE",               OracleType.Char,        1),
                new OracleParameter(":ISSUED",             OracleType.DateTime),
                new OracleParameter(":PAID",               OracleType.DateTime),
                new OracleParameter(":STATUS",             OracleType.Char,        1),
                new OracleParameter(":COMMENTS",           OracleType.VarChar,   300),
                new OracleParameter(":ADDRESS",            OracleType.VarChar,   300),
                new OracleParameter(":CLIENT",             OracleType.Char,        4),
                new OracleParameter(":OWNER",              OracleType.VarChar,    15),
                new OracleParameter(":CURRENCYID",         OracleType.Char,        3),
                new OracleParameter(":ACCOUNTID",          OracleType.VarChar,    20),
                new OracleParameter(":BILLING_START_DATE", OracleType.DateTime),
                new OracleParameter(":BILLING_END_DATE",   OracleType.DateTime),
                new OracleParameter(":FIRMID",             OracleType.VarChar,    20),
                new OracleParameter(":CLIENT_MATTERID",    OracleType.VarChar,    40),
                new OracleParameter(":SIGS",               OracleType.VarChar,    15),
                new OracleParameter(":DESCLINE",           OracleType.VarChar, 200)
            };
            parameters[0].Value  = model.CASENO;
            parameters[1].Value  = model.NOTENUMBER;
            parameters[2].Value  = model.ISSUENUMBER;
            parameters[3].Value  = model.TYPE;
            parameters[4].Value  = model.ISSUED;
            parameters[5].Value  = model.PAID;
            parameters[6].Value  = model.STATUS;
            parameters[7].Value  = model.COMMENTS;
            parameters[8].Value  = model.ADDRESS;
            parameters[9].Value  = model.CLIENT;
            parameters[10].Value = model.OWNER;
            parameters[11].Value = model.CURRENCYID;
            parameters[12].Value = model.ACCOUNTID;
            parameters[13].Value = model.BILLING_START_DATE;
            parameters[14].Value = model.BILLING_END_DATE;
            parameters[15].Value = model.FIRMID;
            parameters[16].Value = model.CLIENT_MATTERID;
            parameters[17].Value = model.SIGS;
            parameters[18].Value = model.DESCLINE;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
示例#5
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Model.BILL DataRowToModel(DataRow row)
 {
     Model.BILL model = new Model.BILL();
     if (row != null)
     {
         if (row["CASENO"] != null)
         {
             model.CASENO = row["CASENO"].ToString();
         }
         if (row["NOTENUMBER"] != null)
         {
             model.NOTENUMBER = row["NOTENUMBER"].ToString();
         }
         if (row["ISSUENUMBER"] != null)
         {
             model.ISSUENUMBER = row["ISSUENUMBER"].ToString();
         }
         if (row["TYPE"] != null)
         {
             model.TYPE = row["TYPE"].ToString();
         }
         if (row["ISSUED"] != null && row["ISSUED"].ToString() != "")
         {
             model.ISSUED = DateTime.Parse(row["ISSUED"].ToString());
         }
         if (row["PAID"] != null && row["PAID"].ToString() != "")
         {
             model.PAID = DateTime.Parse(row["PAID"].ToString());
         }
         if (row["STATUS"] != null)
         {
             model.STATUS = row["STATUS"].ToString();
         }
         if (row["COMMENTS"] != null)
         {
             model.COMMENTS = row["COMMENTS"].ToString();
         }
         if (row["ADDRESS"] != null)
         {
             model.ADDRESS = row["ADDRESS"].ToString();
         }
         if (row["CLIENT"] != null)
         {
             model.CLIENT = row["CLIENT"].ToString();
         }
         if (row["OWNER"] != null)
         {
             model.OWNER = row["OWNER"].ToString();
         }
         if (row["CURRENCYID"] != null)
         {
             model.CURRENCYID = row["CURRENCYID"].ToString();
         }
         if (row["ACCOUNTID"] != null)
         {
             model.ACCOUNTID = row["ACCOUNTID"].ToString();
         }
         if (row["BILLING_START_DATE"] != null && row["BILLING_START_DATE"].ToString() != "")
         {
             model.BILLING_START_DATE = DateTime.Parse(row["BILLING_START_DATE"].ToString());
         }
         if (row["BILLING_END_DATE"] != null && row["BILLING_END_DATE"].ToString() != "")
         {
             model.BILLING_END_DATE = DateTime.Parse(row["BILLING_END_DATE"].ToString());
         }
         if (row["FIRMID"] != null)
         {
             model.FIRMID = row["FIRMID"].ToString();
         }
         if (row["CLIENT_MATTERID"] != null)
         {
             model.CLIENT_MATTERID = row["CLIENT_MATTERID"].ToString();
         }
         if (row["SIGS"] != null)
         {
             model.SIGS = row["SIGS"].ToString();
         }
         if (row["DESCLINE"] != null)
         {
             model.DESCLINE = row["DESCLINE"].ToString();
         }
     }
     return(model);
 }
示例#6
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Model.BILL model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update BILL set ");
            strSql.Append("CASENO=:CASENO,");
            strSql.Append("NOTENUMBER=:NOTENUMBER,");
            strSql.Append("ISSUENUMBER=:ISSUENUMBER,");
            strSql.Append("TYPE=:TYPE,");
            strSql.Append("ISSUED=:ISSUED,");
            strSql.Append("PAID=:PAID,");
            strSql.Append("STATUS=:STATUS,");
            strSql.Append("COMMENTS=:COMMENTS,");
            strSql.Append("ADDRESS=:ADDRESS,");
            strSql.Append("CLIENT=:CLIENT,");
            strSql.Append("OWNER=:OWNER,");
            strSql.Append("CURRENCYID=:CURRENCYID,");
            strSql.Append("ACCOUNTID=:ACCOUNTID,");
            strSql.Append("BILLING_START_DATE=:BILLING_START_DATE,");
            strSql.Append("BILLING_END_DATE=:BILLING_END_DATE,");
            strSql.Append("FIRMID=:FIRMID,");
            strSql.Append("CLIENT_MATTERID=:CLIENT_MATTERID,");
            strSql.Append("SIGS=:SIGS,");
            strSql.Append("DESCLINE=:DESCLINE");
            strSql.Append(" where NOTENUMBER=:NOTENUMBER ");
            OracleParameter[] parameters =
            {
                new OracleParameter(":CASENO",             OracleType.VarChar,    24),
                new OracleParameter(":NOTENUMBER",         OracleType.VarChar,    23),
                new OracleParameter(":ISSUENUMBER",        OracleType.VarChar,    20),
                new OracleParameter(":TYPE",               OracleType.Char,        1),
                new OracleParameter(":ISSUED",             OracleType.DateTime),
                new OracleParameter(":PAID",               OracleType.DateTime),
                new OracleParameter(":STATUS",             OracleType.Char,        1),
                new OracleParameter(":COMMENTS",           OracleType.VarChar,   300),
                new OracleParameter(":ADDRESS",            OracleType.VarChar,   300),
                new OracleParameter(":CLIENT",             OracleType.Char,        4),
                new OracleParameter(":OWNER",              OracleType.VarChar,    15),
                new OracleParameter(":CURRENCYID",         OracleType.Char,        3),
                new OracleParameter(":ACCOUNTID",          OracleType.VarChar,    20),
                new OracleParameter(":BILLING_START_DATE", OracleType.DateTime),
                new OracleParameter(":BILLING_END_DATE",   OracleType.DateTime),
                new OracleParameter(":FIRMID",             OracleType.VarChar,    20),
                new OracleParameter(":CLIENT_MATTERID",    OracleType.VarChar,    40),
                new OracleParameter(":SIGS",               OracleType.VarChar,    15),
                new OracleParameter(":DESCLINE",           OracleType.VarChar, 200)
            };
            parameters[0].Value  = model.CASENO;
            parameters[1].Value  = model.NOTENUMBER;
            parameters[2].Value  = model.ISSUENUMBER;
            parameters[3].Value  = model.TYPE;
            parameters[4].Value  = model.ISSUED;
            parameters[5].Value  = model.PAID;
            parameters[6].Value  = model.STATUS;
            parameters[7].Value  = model.COMMENTS;
            parameters[8].Value  = model.ADDRESS;
            parameters[9].Value  = model.CLIENT;
            parameters[10].Value = model.OWNER;
            parameters[11].Value = model.CURRENCYID;
            parameters[12].Value = model.ACCOUNTID;
            parameters[13].Value = model.BILLING_START_DATE;
            parameters[14].Value = model.BILLING_END_DATE;
            parameters[15].Value = model.FIRMID;
            parameters[16].Value = model.CLIENT_MATTERID;
            parameters[17].Value = model.SIGS;
            parameters[18].Value = model.DESCLINE;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }