/// <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);
}
}
