/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.DROPPING_PATENTBILLITEMTYPE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DROPPING_PATENTBILLITEMTYPE(");
strSql.Append("BILLCODE,BILLTEXT,PATENTCASETYPE,HASQUANTITY,UNIT,DEFOFFICIALFEE,DEFNONOFFICIALFEE,ALGORITHM,F0,F1,F2,F3,F4,F5,COMMENTS)");
strSql.Append(" values (");
strSql.Append(":BILLCODE,:BILLTEXT,:PATENTCASETYPE,:HASQUANTITY,:UNIT,:DEFOFFICIALFEE,:DEFNONOFFICIALFEE,:ALGORITHM,:F0,:F1,:F2,:F3,:F4,:F5,:COMMENTS)");
OracleParameter[] parameters =
{
new OracleParameter(":BILLCODE", OracleType.VarChar, 30),
new OracleParameter(":BILLTEXT", OracleType.VarChar, 100),
new OracleParameter(":PATENTCASETYPE", OracleType.Char, 8),
new OracleParameter(":HASQUANTITY", OracleType.Char, 1),
new OracleParameter(":UNIT", OracleType.Char, 20),
new OracleParameter(":DEFOFFICIALFEE", OracleType.Number, 4),
new OracleParameter(":DEFNONOFFICIALFEE", OracleType.Number, 4),
new OracleParameter(":ALGORITHM", OracleType.VarChar, 15),
new OracleParameter(":F0", OracleType.Number, 4),
new OracleParameter(":F1", OracleType.Number, 4),
new OracleParameter(":F2", OracleType.Number, 4),
new OracleParameter(":F3", OracleType.Number, 4),
new OracleParameter(":F4", OracleType.Number, 4),
new OracleParameter(":F5", OracleType.Number, 4),
new OracleParameter(":COMMENTS", OracleType.VarChar, 2000)
};
parameters[0].Value = model.BILLCODE;
parameters[1].Value = model.BILLTEXT;
parameters[2].Value = model.PATENTCASETYPE;
parameters[3].Value = model.HASQUANTITY;
parameters[4].Value = model.UNIT;
parameters[5].Value = model.DEFOFFICIALFEE;
parameters[6].Value = model.DEFNONOFFICIALFEE;
parameters[7].Value = model.ALGORITHM;
parameters[8].Value = model.F0;
parameters[9].Value = model.F1;
parameters[10].Value = model.F2;
parameters[11].Value = model.F3;
parameters[12].Value = model.F4;
parameters[13].Value = model.F5;
parameters[14].Value = model.COMMENTS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.DROPPING_PATENTBILLITEMTYPE GetModel(string BILLCODE)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select BILLCODE,BILLTEXT,PATENTCASETYPE,HASQUANTITY,UNIT,DEFOFFICIALFEE,DEFNONOFFICIALFEE,ALGORITHM,F0,F1,F2,F3,F4,F5,COMMENTS from DROPPING_PATENTBILLITEMTYPE ");
strSql.Append(" where BILLCODE=:BILLCODE ");
OracleParameter[] parameters =
{
new OracleParameter(":BILLCODE", OracleType.VarChar, 30)
};
parameters[0].Value = BILLCODE;
Model.DROPPING_PATENTBILLITEMTYPE model = new Model.DROPPING_PATENTBILLITEMTYPE();
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.DROPPING_PATENTBILLITEMTYPE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update DROPPING_PATENTBILLITEMTYPE set ");
strSql.Append("BILLCODE=:BILLCODE,");
strSql.Append("BILLTEXT=:BILLTEXT,");
strSql.Append("PATENTCASETYPE=:PATENTCASETYPE,");
strSql.Append("HASQUANTITY=:HASQUANTITY,");
strSql.Append("UNIT=:UNIT,");
strSql.Append("DEFOFFICIALFEE=:DEFOFFICIALFEE,");
strSql.Append("DEFNONOFFICIALFEE=:DEFNONOFFICIALFEE,");
strSql.Append("ALGORITHM=:ALGORITHM,");
strSql.Append("F0=:F0,");
strSql.Append("F1=:F1,");
strSql.Append("F2=:F2,");
strSql.Append("F3=:F3,");
strSql.Append("F4=:F4,");
strSql.Append("F5=:F5,");
strSql.Append("COMMENTS=:COMMENTS");
strSql.Append(" where BILLCODE=:BILLCODE ");
OracleParameter[] parameters =
{
new OracleParameter(":BILLCODE", OracleType.VarChar, 30),
new OracleParameter(":BILLTEXT", OracleType.VarChar, 100),
new OracleParameter(":PATENTCASETYPE", OracleType.Char, 8),
new OracleParameter(":HASQUANTITY", OracleType.Char, 1),
new OracleParameter(":UNIT", OracleType.Char, 20),
new OracleParameter(":DEFOFFICIALFEE", OracleType.Number, 4),
new OracleParameter(":DEFNONOFFICIALFEE", OracleType.Number, 4),
new OracleParameter(":ALGORITHM", OracleType.VarChar, 15),
new OracleParameter(":F0", OracleType.Number, 4),
new OracleParameter(":F1", OracleType.Number, 4),
new OracleParameter(":F2", OracleType.Number, 4),
new OracleParameter(":F3", OracleType.Number, 4),
new OracleParameter(":F4", OracleType.Number, 4),
new OracleParameter(":F5", OracleType.Number, 4),
new OracleParameter(":COMMENTS", OracleType.VarChar, 2000)
};
parameters[0].Value = model.BILLCODE;
parameters[1].Value = model.BILLTEXT;
parameters[2].Value = model.PATENTCASETYPE;
parameters[3].Value = model.HASQUANTITY;
parameters[4].Value = model.UNIT;
parameters[5].Value = model.DEFOFFICIALFEE;
parameters[6].Value = model.DEFNONOFFICIALFEE;
parameters[7].Value = model.ALGORITHM;
parameters[8].Value = model.F0;
parameters[9].Value = model.F1;
parameters[10].Value = model.F2;
parameters[11].Value = model.F3;
parameters[12].Value = model.F4;
parameters[13].Value = model.F5;
parameters[14].Value = model.COMMENTS;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.DROPPING_PATENTBILLITEMTYPE DataRowToModel(DataRow row)
{
Model.DROPPING_PATENTBILLITEMTYPE model = new Model.DROPPING_PATENTBILLITEMTYPE();
if (row != null)
{
if (row["BILLCODE"] != null)
{
model.BILLCODE = row["BILLCODE"].ToString();
}
if (row["BILLTEXT"] != null)
{
model.BILLTEXT = row["BILLTEXT"].ToString();
}
if (row["PATENTCASETYPE"] != null)
{
model.PATENTCASETYPE = row["PATENTCASETYPE"].ToString();
}
if (row["HASQUANTITY"] != null)
{
model.HASQUANTITY = row["HASQUANTITY"].ToString();
}
if (row["UNIT"] != null)
{
model.UNIT = row["UNIT"].ToString();
}
if (row["DEFOFFICIALFEE"] != null && row["DEFOFFICIALFEE"].ToString() != "")
{
model.DEFOFFICIALFEE = decimal.Parse(row["DEFOFFICIALFEE"].ToString());
}
if (row["DEFNONOFFICIALFEE"] != null && row["DEFNONOFFICIALFEE"].ToString() != "")
{
model.DEFNONOFFICIALFEE = decimal.Parse(row["DEFNONOFFICIALFEE"].ToString());
}
if (row["ALGORITHM"] != null)
{
model.ALGORITHM = row["ALGORITHM"].ToString();
}
if (row["F0"] != null && row["F0"].ToString() != "")
{
model.F0 = decimal.Parse(row["F0"].ToString());
}
if (row["F1"] != null && row["F1"].ToString() != "")
{
model.F1 = decimal.Parse(row["F1"].ToString());
}
if (row["F2"] != null && row["F2"].ToString() != "")
{
model.F2 = decimal.Parse(row["F2"].ToString());
}
if (row["F3"] != null && row["F3"].ToString() != "")
{
model.F3 = decimal.Parse(row["F3"].ToString());
}
if (row["F4"] != null && row["F4"].ToString() != "")
{
model.F4 = decimal.Parse(row["F4"].ToString());
}
if (row["F5"] != null && row["F5"].ToString() != "")
{
model.F5 = decimal.Parse(row["F5"].ToString());
}
if (row["COMMENTS"] != null)
{
model.COMMENTS = row["COMMENTS"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.DROPPING_PATENTBILLITEMTYPE model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Model.DROPPING_PATENTBILLITEMTYPE model)
{
return(dal.Add(model));
}
