Example #1
0
 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;
 }
Example #2
0
 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);
 }
Example #3
0
 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);
 }
Example #4
0
 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;
 }
Example #5
0
 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;
 }