public int Add(SFProCountStandardModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
StringBuilder builder2 = new StringBuilder();
StringBuilder builder3 = new StringBuilder();
if (model.PK != null)
{
builder2.Append("PK,");
builder3.Append("'" + model.PK + "',");
}
if (model.SFPROJECTPK != null)
{
builder2.Append("SFPROJECTPK,");
builder3.Append("'" + model.SFPROJECTPK + "',");
}
if (model.COUNTTYPENAME != null)
{
builder2.Append("COUNTTYPENAME,");
builder3.Append("'" + model.COUNTTYPENAME + "',");
}
if (model.COUNTTYPEPK != null)
{
builder2.Append("COUNTTYPEPK,");
builder3.Append("'" + model.COUNTTYPEPK + "',");
}
builder2.Append("STANDARDMIN,");
builder3.Append(model.STANDARDMIN + ",");
builder2.Append("STANDARDMAX,");
builder3.Append(model.STANDARDMAX + ",");
builder2.Append("COUNTSTANDARD,");
builder3.Append(model.COUNTSTANDARD + ",");
if (model.COMPANYPK != null)
{
builder2.Append("COMPANYPK,");
builder3.Append("'" + model.COMPANYPK + "',");
}
if (model.BRANCHPK != null)
{
builder2.Append("BRANCHPK,");
builder3.Append("'" + model.BRANCHPK + "',");
}
if (model.TACHEPK != null)
{
builder2.Append("TACHEPK,");
builder3.Append("'" + model.TACHEPK + "',");
}
if (model.PAPERSPK != null)
{
builder2.Append("PAPERSPK,");
builder3.Append("'" + model.PAPERSPK + "',");
}
if (model.POLICYGIST != null)
{
builder2.Append("POLICYGIST,");
builder3.Append("'" + model.POLICYGIST + "',");
}
if (model.COLLECTOBJECTPK != null)
{
builder2.Append("COLLECTOBJECTPK,");
builder3.Append("'" + model.COLLECTOBJECTPK + "',");
}
if (model.METERINGPK != null)
{
builder2.Append("METERINGPK,");
builder3.Append("'" + model.METERINGPK + "',");
}
if (model.METERINGUNITPK != null)
{
builder2.Append("METERINGUNITPK,");
builder3.Append("'" + model.METERINGUNITPK + "',");
}
if (model.REMARK != null)
{
builder2.Append("REMARK,");
builder3.Append("'" + model.REMARK + "',");
}
if (model.MJ != null)
{
builder2.Append("MJ,");
builder3.Append("'" + model.MJ + "',");
}
if (model.DJ != null)
{
builder2.Append("DJ,");
builder3.Append("'" + model.DJ + "',");
}
if (model.JSJE != null)
{
builder2.Append("JSJE,");
builder3.Append("'" + model.JSJE + "',");
}
builder.Append("insert into GOV_TC_DB_SFPROCOUNTSTANDARD(");
builder.Append(builder2.ToString().Remove(builder2.Length - 1));
builder.Append(")");
builder.Append(" values (");
builder.Append(builder3.ToString().Remove(builder3.Length - 1));
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public SFProCountStandardModel[] GetModels(string strWhere, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append(this.GetSql());
if (strWhere != "")
{
builder.Append(" where " + strWhere);
}
OracleParameter[] parameters = null;
DataSet set = dbo.BackDataSet(builder.ToString(), parameters, "");
SFProCountStandardModel[] modelArray = null;
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
modelArray = new SFProCountStandardModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new SFProCountStandardModel();
modelArray[i] = this.GetModel(set.Tables[0].Rows[i]);
}
return modelArray;
}
public int Update(SFProCountStandardModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("update GOV_TC_DB_SFPROCOUNTSTANDARD set ");
if (model.SFPROJECTPK != null)
{
builder.Append("SFPROJECTPK='" + model.SFPROJECTPK + "',");
}
if (model.COUNTTYPENAME != null)
{
builder.Append("COUNTTYPENAME='" + model.COUNTTYPENAME + "',");
}
if (model.COUNTTYPEPK != null)
{
builder.Append("COUNTTYPEPK='" + model.COUNTTYPEPK + "',");
}
builder.Append("STANDARDMIN=" + model.STANDARDMIN + ",");
builder.Append("STANDARDMAX=" + model.STANDARDMAX + ",");
builder.Append("COUNTSTANDARD=" + model.COUNTSTANDARD + ",");
if (model.COMPANYPK != null)
{
builder.Append("COMPANYPK='" + model.COMPANYPK + "',");
}
if (model.BRANCHPK != null)
{
builder.Append("BRANCHPK='" + model.BRANCHPK + "',");
}
if (model.TACHEPK != null)
{
builder.Append("TACHEPK='" + model.TACHEPK + "',");
}
if (model.PAPERSPK != null)
{
builder.Append("PAPERSPK='" + model.PAPERSPK + "',");
}
if (model.POLICYGIST != null)
{
builder.Append("POLICYGIST='" + model.POLICYGIST + "',");
}
if (model.COLLECTOBJECTPK != null)
{
builder.Append("COLLECTOBJECTPK='" + model.COLLECTOBJECTPK + "',");
}
if (model.METERINGPK != null)
{
builder.Append("METERINGPK='" + model.METERINGPK + "',");
}
if (model.METERINGUNITPK != null)
{
builder.Append("METERINGUNITPK='" + model.METERINGUNITPK + "',");
}
if (model.REMARK != null)
{
builder.Append("REMARK='" + model.REMARK + "',");
}
if (model.MJ != null)
{
builder.Append("MJ='" + model.MJ + "',");
}
if (model.DJ != null)
{
builder.Append("DJ='" + model.DJ + "',");
}
if (model.JSJE != null)
{
builder.Append("JSJE='" + model.JSJE + "',");
}
int startIndex = builder.ToString().LastIndexOf(",");
builder.Remove(startIndex, 1);
builder.Append(" where PK='" + model.PK + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public SFProCountStandardModel GetModel(DataRow dr)
{
SFProCountStandardModel model = new SFProCountStandardModel {
PK = dr["PK"].ToString(),
SFPROJECTPK = dr["SFPROJECTPK"].ToString(),
COUNTTYPENAME = dr["COUNTTYPENAME"].ToString(),
COUNTTYPEPK = dr["COUNTTYPEPK"].ToString()
};
if (dr["STANDARDMIN"].ToString() != "")
{
model.STANDARDMIN = int.Parse(dr["STANDARDMIN"].ToString());
}
if (dr["STANDARDMAX"].ToString() != "")
{
model.STANDARDMAX = int.Parse(dr["STANDARDMAX"].ToString());
}
if (dr["COUNTSTANDARD"].ToString() != "")
{
model.COUNTSTANDARD = int.Parse(dr["COUNTSTANDARD"].ToString());
}
model.COMPANYPK = dr["COMPANYPK"].ToString();
model.BRANCHPK = dr["BRANCHPK"].ToString();
model.TACHEPK = dr["TACHEPK"].ToString();
model.PAPERSPK = dr["PAPERSPK"].ToString();
model.POLICYGIST = dr["POLICYGIST"].ToString();
model.COLLECTOBJECTPK = dr["COLLECTOBJECTPK"].ToString();
model.METERINGPK = dr["METERINGPK"].ToString();
model.METERINGUNITPK = dr["METERINGUNITPK"].ToString();
model.REMARK = dr["REMARK"].ToString();
model.MJ = dr["MJ"].ToString();
model.DJ = dr["DJ"].ToString();
model.JSJE = dr["JSJE"].ToString();
return model;
}