public int Add(SFProExecuteStandardModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into GOV_TC_DB_SFProExecuteStandard(");
builder.Append("SFProjectPK,CountStandardPK,BuildingProPK,ExecuteStandard,Remark");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.SFProjectPK + "',");
builder.Append("'" + model.CountStandardPK + "',");
builder.Append("'" + model.BuildingProPK + "',");
builder.Append(model.ExecuteStandard + ",");
builder.Append("'" + model.Remark + "'");
builder.Append(")");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public SFProExecuteStandardModel GetModel(DataRow dr)
{
SFProExecuteStandardModel model = new SFProExecuteStandardModel {
PK = dr["PK"].ToString(),
BuildingProPK = dr["BuildingProPK"].ToString(),
CountStandardPK = dr["CountStandardPK"].ToString(),
SFProjectPK = dr["SFProjectPK"].ToString()
};
if (dr["ExecuteStandard"].ToString() != "")
{
model.ExecuteStandard = decimal.Parse(dr["ExecuteStandard"].ToString());
}
model.Remark = dr["Remark"].ToString();
return model;
}
public SFProExecuteStandardModel[] 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, "");
SFProExecuteStandardModel[] modelArray = null;
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
modelArray = new SFProExecuteStandardModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new SFProExecuteStandardModel();
modelArray[i] = this.GetModel(set.Tables[0].Rows[i]);
}
return modelArray;
}
public int Update(SFProExecuteStandardModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("update GOV_TC_DB_SFProExecuteStandard set ");
builder.Append("SFProjectPK='" + model.SFProjectPK + "',");
builder.Append("CountStandardPK='" + model.CountStandardPK + "',");
builder.Append("BuildingProPK='" + model.BuildingProPK + "',");
builder.Append("ExecuteStandard=" + model.ExecuteStandard + ",");
builder.Append("Remark='" + model.Remark + "'");
builder.Append(" where PK='" + model.PK + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}