/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.BILLFEEMNT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BILLFEEMNT set "); strSql.Append("FEEID=:FEEID,"); strSql.Append("NOTENO=:NOTENO,"); strSql.Append("CASENO=:CASENO,"); strSql.Append("CASETYPE=:CASETYPE,"); strSql.Append("CLIENTNO=:CLIENTNO,"); strSql.Append("AMOUNT=:AMOUNT,"); strSql.Append("TYP_OR_GRP=:TYP_OR_GRP,"); strSql.Append("PAYCURRENCY=:PAYCURRENCY,"); strSql.Append("PAYDATE=:PAYDATE,"); strSql.Append("BILLDATE=:BILLDATE,"); strSql.Append("PAYMETHOD=:PAYMETHOD,"); strSql.Append("STATUS=:STATUS,"); strSql.Append("CHECKBY=:CHECKBY"); strSql.Append(" where FEEID=:FEEID "); OracleParameter[] parameters = { new OracleParameter(":FEEID", OracleType.VarChar, 50), new OracleParameter(":NOTENO", OracleType.VarChar, 20), new OracleParameter(":CASENO", OracleType.VarChar, 30), new OracleParameter(":CASETYPE", OracleType.VarChar, 20), new OracleParameter(":CLIENTNO", OracleType.VarChar, 10), new OracleParameter(":AMOUNT", OracleType.Number, 9), new OracleParameter(":TYP_OR_GRP", OracleType.VarChar, 50), new OracleParameter(":PAYCURRENCY", OracleType.VarChar, 10), new OracleParameter(":PAYDATE", OracleType.DateTime), new OracleParameter(":BILLDATE", OracleType.DateTime), new OracleParameter(":PAYMETHOD", OracleType.VarChar, 40), new OracleParameter(":STATUS", OracleType.VarChar, 10), new OracleParameter(":CHECKBY", OracleType.VarChar, 10) }; parameters[0].Value = model.FEEID; parameters[1].Value = model.NOTENO; parameters[2].Value = model.CASENO; parameters[3].Value = model.CASETYPE; parameters[4].Value = model.CLIENTNO; parameters[5].Value = model.AMOUNT; parameters[6].Value = model.TYP_OR_GRP; parameters[7].Value = model.PAYCURRENCY; parameters[8].Value = model.PAYDATE; parameters[9].Value = model.BILLDATE; parameters[10].Value = model.PAYMETHOD; parameters[11].Value = model.STATUS; parameters[12].Value = model.CHECKBY; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.BILLFEEMNT DataRowToModel(DataRow row) { Model.BILLFEEMNT model = new Model.BILLFEEMNT(); if (row != null) { if (row["FEEID"] != null) { model.FEEID = row["FEEID"].ToString(); } if (row["NOTENO"] != null) { model.NOTENO = row["NOTENO"].ToString(); } if (row["CASENO"] != null) { model.CASENO = row["CASENO"].ToString(); } if (row["CASETYPE"] != null) { model.CASETYPE = row["CASETYPE"].ToString(); } if (row["CLIENTNO"] != null) { model.CLIENTNO = row["CLIENTNO"].ToString(); } if (row["AMOUNT"] != null && row["AMOUNT"].ToString() != "") { model.AMOUNT = decimal.Parse(row["AMOUNT"].ToString()); } if (row["TYP_OR_GRP"] != null) { model.TYP_OR_GRP = row["TYP_OR_GRP"].ToString(); } if (row["PAYCURRENCY"] != null) { model.PAYCURRENCY = row["PAYCURRENCY"].ToString(); } if (row["PAYDATE"] != null && row["PAYDATE"].ToString() != "") { model.PAYDATE = DateTime.Parse(row["PAYDATE"].ToString()); } if (row["BILLDATE"] != null && row["BILLDATE"].ToString() != "") { model.BILLDATE = DateTime.Parse(row["BILLDATE"].ToString()); } if (row["PAYMETHOD"] != null) { model.PAYMETHOD = row["PAYMETHOD"].ToString(); } if (row["STATUS"] != null) { model.STATUS = row["STATUS"].ToString(); } if (row["CHECKBY"] != null) { model.CHECKBY = row["CHECKBY"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.BILLFEEMNT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BILLFEEMNT("); strSql.Append("FEEID,NOTENO,CASENO,CASETYPE,CLIENTNO,AMOUNT,TYP_OR_GRP,PAYCURRENCY,PAYDATE,BILLDATE,PAYMETHOD,STATUS,CHECKBY)"); strSql.Append(" values ("); strSql.Append(":FEEID,:NOTENO,:CASENO,:CASETYPE,:CLIENTNO,:AMOUNT,:TYP_OR_GRP,:PAYCURRENCY,:PAYDATE,:BILLDATE,:PAYMETHOD,:STATUS,:CHECKBY)"); OracleParameter[] parameters = { new OracleParameter(":FEEID", OracleType.VarChar, 50), new OracleParameter(":NOTENO", OracleType.VarChar, 20), new OracleParameter(":CASENO", OracleType.VarChar, 30), new OracleParameter(":CASETYPE", OracleType.VarChar, 20), new OracleParameter(":CLIENTNO", OracleType.VarChar, 10), new OracleParameter(":AMOUNT", OracleType.Number, 9), new OracleParameter(":TYP_OR_GRP", OracleType.VarChar, 50), new OracleParameter(":PAYCURRENCY", OracleType.VarChar, 10), new OracleParameter(":PAYDATE", OracleType.DateTime), new OracleParameter(":BILLDATE", OracleType.DateTime), new OracleParameter(":PAYMETHOD", OracleType.VarChar, 40), new OracleParameter(":STATUS", OracleType.VarChar, 10), new OracleParameter(":CHECKBY", OracleType.VarChar, 10) }; parameters[0].Value = model.FEEID; parameters[1].Value = model.NOTENO; parameters[2].Value = model.CASENO; parameters[3].Value = model.CASETYPE; parameters[4].Value = model.CLIENTNO; parameters[5].Value = model.AMOUNT; parameters[6].Value = model.TYP_OR_GRP; parameters[7].Value = model.PAYCURRENCY; parameters[8].Value = model.PAYDATE; parameters[9].Value = model.BILLDATE; parameters[10].Value = model.PAYMETHOD; parameters[11].Value = model.STATUS; parameters[12].Value = model.CHECKBY; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.BILLFEEMNT GetModel(string FEEID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select FEEID,NOTENO,CASENO,CASETYPE,CLIENTNO,AMOUNT,TYP_OR_GRP,PAYCURRENCY,PAYDATE,BILLDATE,PAYMETHOD,STATUS,CHECKBY from BILLFEEMNT "); strSql.Append(" where FEEID=:FEEID "); OracleParameter[] parameters = { new OracleParameter(":FEEID", OracleType.VarChar, 50) }; parameters[0].Value = FEEID; Model.BILLFEEMNT model = new Model.BILLFEEMNT(); 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.BILLFEEMNT model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Model.BILLFEEMNT model) { return(dal.Add(model)); }