コード例 #1
0
 public List<GOV_TC_DB_COMPANYDATADZ_Model> DataTableToList(DataTable dt)
 {
     List<GOV_TC_DB_COMPANYDATADZ_Model> list = new List<GOV_TC_DB_COMPANYDATADZ_Model>();
     int count = dt.Rows.Count;
     if (count > 0)
     {
         for (int i = 0; i < count; i++)
         {
             GOV_TC_DB_COMPANYDATADZ_Model item = new GOV_TC_DB_COMPANYDATADZ_Model();
             if (dt.Rows[i]["PK"].ToString() != "")
             {
                 item.PK = int.Parse(dt.Rows[i]["PK"].ToString());
             }
             item.DATANAME = dt.Rows[i]["DATANAME"].ToString();
             item.TABLENAME = dt.Rows[i]["TABLENAME"].ToString();
             item.COLUMNNAME = dt.Rows[i]["COLUMNNAME"].ToString();
             item.COMPANYBH = dt.Rows[i]["COMPANYBH"].ToString();
             item.SHOWNAME = dt.Rows[i]["SHOWNAME"].ToString();
             item.IP = dt.Rows[i]["IP"].ToString();
             item.USERID = dt.Rows[i]["USERID"].ToString();
             item.PWD = dt.Rows[i]["PWD"].ToString();
             list.Add(item);
         }
     }
     return list;
 }
コード例 #2
0
 public bool Add(GOV_TC_DB_COMPANYDATADZ_Model model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into GOV_TC_DB_COMPANYDATADZ(");
     builder.Append("PK,DATANAME,TABLENAME,COLUMNNAME,COMPANYBH,SHOWNAME,IP,USERID,PWD)");
     builder.Append(" values (");
     builder.Append(":PK,:DATANAME,:TABLENAME,:COLUMNNAME,:COMPANYBH,:SHOWNAME,:IP,:USERID,:PWD)");
     OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PK", OracleType.Number, 4), new OracleParameter(":DATANAME", OracleType.VarChar, 40), new OracleParameter(":TABLENAME", OracleType.VarChar, 100), new OracleParameter(":COLUMNNAME", OracleType.VarChar, 0xff), new OracleParameter(":COMPANYBH", OracleType.VarChar, 40), new OracleParameter(":SHOWNAME", OracleType.VarChar, 40), new OracleParameter(":IP", OracleType.VarChar, 40), new OracleParameter(":USERID", OracleType.VarChar, 40), new OracleParameter(":PWD", OracleType.VarChar, 40) };
     cmdParms[0].Value = model.PK;
     cmdParms[1].Value = model.DATANAME;
     cmdParms[2].Value = model.TABLENAME;
     cmdParms[3].Value = model.COLUMNNAME;
     cmdParms[4].Value = model.COMPANYBH;
     cmdParms[5].Value = model.SHOWNAME;
     cmdParms[6].Value = model.IP;
     cmdParms[7].Value = model.USERID;
     cmdParms[8].Value = model.PWD;
     return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
 }
コード例 #3
0
 public GOV_TC_DB_COMPANYDATADZ_Model GetModel(long PK)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("select PK,DATANAME,TABLENAME,COLUMNNAME,COMPANYBH,db_company.name COMPANYNAME,SHOWNAME,IP,USERID,PWD from GOV_TC_DB_COMPANYDATADZ ");
     builder.Append(" left join db_company on db_company.pk_corp=GOV_TC_DB_COMPANYDATADZ.COMPANYBH ");
     builder.Append(" where PK=:PK ");
     OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":PK", OracleType.Number, 4) };
     cmdParms[0].Value = PK;
     GOV_TC_DB_COMPANYDATADZ_Model model = new GOV_TC_DB_COMPANYDATADZ_Model();
     DataSet set = DbHelperOra.Query(builder.ToString(), cmdParms);
     if (set.Tables[0].Rows.Count <= 0)
     {
         return null;
     }
     if (set.Tables[0].Rows[0]["PK"].ToString() != "")
     {
         model.PK = long.Parse(set.Tables[0].Rows[0]["PK"].ToString());
     }
     model.DATANAME = set.Tables[0].Rows[0]["DATANAME"].ToString();
     model.TABLENAME = set.Tables[0].Rows[0]["TABLENAME"].ToString();
     model.COLUMNNAME = set.Tables[0].Rows[0]["COLUMNNAME"].ToString();
     model.COMPANYBH = set.Tables[0].Rows[0]["COMPANYBH"].ToString();
     model.COMPANYNAME = set.Tables[0].Rows[0]["COMPANYNAME"].ToString();
     model.SHOWNAME = set.Tables[0].Rows[0]["SHOWNAME"].ToString();
     model.IP = set.Tables[0].Rows[0]["IP"].ToString();
     model.USERID = set.Tables[0].Rows[0]["USERID"].ToString();
     model.PWD = set.Tables[0].Rows[0]["PWD"].ToString();
     return model;
 }
コード例 #4
0
 public bool Update(GOV_TC_DB_COMPANYDATADZ_Model model)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("update GOV_TC_DB_COMPANYDATADZ set ");
     builder.Append("DATANAME=:DATANAME,");
     builder.Append("TABLENAME=:TABLENAME,");
     builder.Append("COLUMNNAME=:COLUMNNAME,");
     builder.Append("COMPANYBH=:COMPANYBH,");
     builder.Append("SHOWNAME=:SHOWNAME,");
     builder.Append("IP=:IP,");
     builder.Append("USERID=:USERID,");
     builder.Append("PWD=:PWD");
     builder.Append(" where PK=:PK ");
     OracleParameter[] cmdParms = new OracleParameter[] { new OracleParameter(":DATANAME", OracleType.VarChar, 40), new OracleParameter(":TABLENAME", OracleType.VarChar, 100), new OracleParameter(":COLUMNNAME", OracleType.VarChar, 0xff), new OracleParameter(":COMPANYBH", OracleType.VarChar, 40), new OracleParameter(":SHOWNAME", OracleType.VarChar, 40), new OracleParameter(":IP", OracleType.VarChar, 40), new OracleParameter(":USERID", OracleType.VarChar, 40), new OracleParameter(":PWD", OracleType.VarChar, 40), new OracleParameter(":PK", OracleType.Number, 4) };
     cmdParms[0].Value = model.DATANAME;
     cmdParms[1].Value = model.TABLENAME;
     cmdParms[2].Value = model.COLUMNNAME;
     cmdParms[3].Value = model.COMPANYBH;
     cmdParms[4].Value = model.SHOWNAME;
     cmdParms[5].Value = model.IP;
     cmdParms[6].Value = model.USERID;
     cmdParms[7].Value = model.PWD;
     cmdParms[8].Value = model.PK;
     return (DbHelperOra.ExecuteSql(builder.ToString(), cmdParms) > 0);
 }
コード例 #5
0
 public bool Add(GOV_TC_DB_COMPANYDATADZ_Model model)
 {
     return this.dal.Add(model);
 }
コード例 #6
0
 public bool Update(GOV_TC_DB_COMPANYDATADZ_Model model)
 {
     return this.dal.Update(model);
 }
コード例 #7
0
 private void GetModel(ref GOV_TC_DB_COMPANYDATADZ_Model model)
 {
     if (model == null)
     {
         model = new GOV_TC_DB_COMPANYDATADZ_Model();
     }
     model.DATANAME = this.dllDATANAME.SelectedItem.Value;
     model.COMPANYBH = this.txtCOMPANYBH.Value;
     model.SHOWNAME = this.dllDATANAME.SelectedItem.Text;
 }