public static SFProjectModel[] GetTacheSFMessByTachePK(string TachePK, DB_OPT dbo)
{
string strSql = "select distinct SFPROJECTPK,NAME from GOV_TC_VIEW_SFPROCOUNTSTANDARD where TACHEPK='" + TachePK + "'";
DataSet set = dbo.BackDataSet(strSql, null);
SFProjectModel[] modelArray = null;
if ((set != null) && (set.Tables[0].Rows.Count > 0))
{
modelArray = new SFProjectModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new SFProjectModel();
modelArray[i].PK = set.Tables[0].Rows[0]["SFPROJECTPK"].ToString();
modelArray[i].NAME = set.Tables[0].Rows[0]["NAME"].ToString();
}
}
return modelArray;
}
public int Add(SFProjectModel 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.BH != null)
{
builder2.Append("BH,");
builder3.Append("'" + model.BH + "',");
}
if (model.SFCODE != null)
{
builder2.Append("SFCODE,");
builder3.Append("'" + model.SFCODE + "',");
}
if (model.NAME != null)
{
builder2.Append("NAME,");
builder3.Append("'" + model.NAME + "',");
}
if (model.TAXFEEKINDPK != null)
{
builder2.Append("TAXFEEKINDPK,");
builder3.Append("'" + model.TAXFEEKINDPK + "',");
}
if (model.ISMUST != null)
{
builder2.Append("ISMUST,");
builder3.Append("'" + model.ISMUST + "',");
}
if (model.PAYORDER.HasValue)
{
builder2.Append("PAYORDER,");
builder3.Append(model.PAYORDER + ",");
}
if (model.REMARK != null)
{
builder2.Append("REMARK,");
builder3.Append("'" + model.REMARK + "',");
}
if (model.ISCANGETBEFOR != null)
{
builder2.Append("ISCANGETBEFOR,");
builder3.Append("'" + model.ISCANGETBEFOR + "',");
}
if (model.ISCANSETBACK != null)
{
builder2.Append("ISCANSETBACK,");
builder3.Append("'" + model.ISCANSETBACK + "',");
}
if (model.ISCANBZBACK != null)
{
builder2.Append("ISCANBZBACK,");
builder3.Append("'" + model.ISCANBZBACK + "',");
}
if (model.ISYJJE != null)
{
builder2.Append("ISYJJE,");
builder3.Append("'" + model.ISYJJE + "',");
}
if (model.ISZNJ != null)
{
builder2.Append("ISZNJ,");
builder3.Append("'" + model.ISZNJ + "',");
}
if (model.ZNJBZ.HasValue)
{
builder2.Append("ZNJBZ,");
builder3.Append(model.ZNJBZ + ",");
}
if (model.UNITTYPEPK != null)
{
builder2.Append("UNITTYPEPK,");
builder3.Append("'" + model.UNITTYPEPK + "',");
}
builder.Append("insert into GOV_TC_DB_SFPROJECT(");
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 int Update(SFProjectModel model, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("update GOV_TC_DB_SFPROJECT set ");
if (model.BH != null)
{
builder.Append("BH='" + model.BH + "',");
}
if (model.SFCODE != null)
{
builder.Append("SFCODE='" + model.SFCODE + "',");
}
if (model.NAME != null)
{
builder.Append("NAME='" + model.NAME + "',");
}
if (model.TAXFEEKINDPK != null)
{
builder.Append("TAXFEEKINDPK='" + model.TAXFEEKINDPK + "',");
}
if (model.ISMUST != null)
{
builder.Append("ISMUST='" + model.ISMUST + "',");
}
if (model.PAYORDER.HasValue)
{
builder.Append("PAYORDER=" + model.PAYORDER + ",");
}
if (model.REMARK != null)
{
builder.Append("REMARK='" + model.REMARK + "',");
}
if (model.ISCANGETBEFOR != null)
{
builder.Append("ISCANGETBEFOR='" + model.ISCANGETBEFOR + "',");
}
if (model.ISCANSETBACK != null)
{
builder.Append("ISCANSETBACK='" + model.ISCANSETBACK + "',");
}
if (model.ISCANBZBACK != null)
{
builder.Append("ISCANBZBACK='" + model.ISCANBZBACK + "',");
}
if (model.ISYJJE != null)
{
builder.Append("ISYJJE='" + model.ISYJJE + "',");
}
if (model.ISZNJ != null)
{
builder.Append("ISZNJ='" + model.ISZNJ + "',");
}
if (model.ZNJBZ.HasValue)
{
builder.Append("ZNJBZ=" + model.ZNJBZ + ",");
}
if (model.UNITTYPEPK != null)
{
builder.Append("UNITTYPEPK='" + model.UNITTYPEPK + "',");
}
int startIndex = builder.ToString().LastIndexOf(",");
builder.Remove(startIndex, 1);
builder.Append(" where PK='" + model.PK + "' ");
return dbo.ExecutionIsSucess(builder.ToString(), null);
}
public SFProjectModel[] 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, "");
SFProjectModel[] modelArray = null;
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
modelArray = new SFProjectModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new SFProjectModel();
modelArray[i] = this.GetModel(set.Tables[0].Rows[i]);
}
return modelArray;
}
public SFProjectModel GetModel(DataRow dr)
{
SFProjectModel model = new SFProjectModel {
PK = dr["PK"].ToString(),
BH = dr["BH"].ToString(),
SFCODE = dr["SFCODE"].ToString(),
NAME = dr["NAME"].ToString(),
TAXFEEKINDPK = dr["TAXFEEKINDPK"].ToString(),
ISMUST = dr["ISMUST"].ToString()
};
if (dr["PAYORDER"].ToString() != "")
{
model.PAYORDER = new int?(int.Parse(dr["PAYORDER"].ToString()));
}
if (dr["ZNJBZ"].ToString() != "")
{
model.ZNJBZ = new decimal?(int.Parse(dr["ZNJBZ"].ToString()));
}
model.REMARK = dr["REMARK"].ToString();
model.ISCANGETBEFOR = dr["ISCANGETBEFOR"].ToString();
model.ISYJJE = dr["ISYJJE"].ToString();
model.ISCANSETBACK = dr["ISCANSETBACK"].ToString();
model.ISCANBZBACK = dr["ISCANBZBACK"].ToString();
model.ISZNJ = dr["ISZNJ"].ToString();
model.UNITTYPEPK = dr["UNITTYPEPK"].ToString();
return model;
}
