/// <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); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.BILL model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.BILL model) { return(dal.Add(model)); }
/// <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); } }
/// <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); }
/// <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); } }