/// <summary> /// 得到一个对象实体 /// </summary> public Parking.Core.Model.PBA_MERCHANT_INFO GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,MERCHANT_NAME,MERCHANT_CORPORATION,MERCHANT_CERTIFICATE_NO,MERCHANT_LOGO,MERCHANT_ADDRESS,MERCHANT_TEL,MERCHANT_CONTACTS,MERCHANT_QQ,MERCHANT_WECHART,MERCHANT_PHONE,MERCHANT_ID_CARD,MERCHANT_TYPE,MERCHANT_NATURE,MERCHANT_REPUTATION_LEVEL,MERCHANT_ENABLE,MERCHANT_CREATE_USER_NAME,MERCHANT_CREATE_TIME,MERCHANT_IS_BOND,MERCHANT_BOND from PBA_MERCHANT_INFO "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 32) }; parameters[0].Value = ID; Parking.Core.Model.PBA_MERCHANT_INFO model = new Parking.Core.Model.PBA_MERCHANT_INFO(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Parking.Core.Model.PBA_MERCHANT_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PBA_MERCHANT_INFO("); strSql.Append("ID,MERCHANT_NAME,MERCHANT_CORPORATION,MERCHANT_CERTIFICATE_NO,MERCHANT_LOGO,MERCHANT_ADDRESS,MERCHANT_TEL,MERCHANT_CONTACTS,MERCHANT_QQ,MERCHANT_WECHART,MERCHANT_PHONE,MERCHANT_ID_CARD,MERCHANT_TYPE,MERCHANT_NATURE,MERCHANT_REPUTATION_LEVEL,MERCHANT_ENABLE,MERCHANT_CREATE_USER_NAME,MERCHANT_CREATE_TIME,MERCHANT_IS_BOND,MERCHANT_BOND)"); strSql.Append(" values ("); strSql.Append("@ID,@MERCHANT_NAME,@MERCHANT_CORPORATION,@MERCHANT_CERTIFICATE_NO,@MERCHANT_LOGO,@MERCHANT_ADDRESS,@MERCHANT_TEL,@MERCHANT_CONTACTS,@MERCHANT_QQ,@MERCHANT_WECHART,@MERCHANT_PHONE,@MERCHANT_ID_CARD,@MERCHANT_TYPE,@MERCHANT_NATURE,@MERCHANT_REPUTATION_LEVEL,@MERCHANT_ENABLE,@MERCHANT_CREATE_USER_NAME,@MERCHANT_CREATE_TIME,@MERCHANT_IS_BOND,@MERCHANT_BOND)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.VarChar, 32), new SqlParameter("@MERCHANT_NAME", SqlDbType.VarChar, 100), new SqlParameter("@MERCHANT_CORPORATION", SqlDbType.VarChar, 50), new SqlParameter("@MERCHANT_CERTIFICATE_NO", SqlDbType.VarChar, 100), new SqlParameter("@MERCHANT_LOGO", SqlDbType.VarChar, 500), new SqlParameter("@MERCHANT_ADDRESS", SqlDbType.VarChar, 300), new SqlParameter("@MERCHANT_TEL", SqlDbType.VarChar, 30), new SqlParameter("@MERCHANT_CONTACTS", SqlDbType.VarChar, 50), new SqlParameter("@MERCHANT_QQ", SqlDbType.VarChar, 50), new SqlParameter("@MERCHANT_WECHART", SqlDbType.VarChar, 50), new SqlParameter("@MERCHANT_PHONE", SqlDbType.VarChar, 20), new SqlParameter("@MERCHANT_ID_CARD", SqlDbType.VarChar, 50), new SqlParameter("@MERCHANT_TYPE", SqlDbType.Int, 4), new SqlParameter("@MERCHANT_NATURE", SqlDbType.Int, 4), new SqlParameter("@MERCHANT_REPUTATION_LEVEL", SqlDbType.Int, 4), new SqlParameter("@MERCHANT_ENABLE", SqlDbType.Int, 4), new SqlParameter("@MERCHANT_CREATE_USER_NAME", SqlDbType.VarChar, 50), new SqlParameter("@MERCHANT_CREATE_TIME", SqlDbType.DateTime), new SqlParameter("@MERCHANT_IS_BOND", SqlDbType.Int, 4), new SqlParameter("@MERCHANT_BOND", SqlDbType.Decimal, 9) }; parameters[0].Value = model.ID; parameters[1].Value = model.MERCHANT_NAME; parameters[2].Value = model.MERCHANT_CORPORATION; parameters[3].Value = model.MERCHANT_CERTIFICATE_NO; parameters[4].Value = model.MERCHANT_LOGO; parameters[5].Value = model.MERCHANT_ADDRESS; parameters[6].Value = model.MERCHANT_TEL; parameters[7].Value = model.MERCHANT_CONTACTS; parameters[8].Value = model.MERCHANT_QQ; parameters[9].Value = model.MERCHANT_WECHART; parameters[10].Value = model.MERCHANT_PHONE; parameters[11].Value = model.MERCHANT_ID_CARD; parameters[12].Value = model.MERCHANT_TYPE; parameters[13].Value = model.MERCHANT_NATURE; parameters[14].Value = model.MERCHANT_REPUTATION_LEVEL; parameters[15].Value = model.MERCHANT_ENABLE; parameters[16].Value = model.MERCHANT_CREATE_USER_NAME; parameters[17].Value = model.MERCHANT_CREATE_TIME; parameters[18].Value = model.MERCHANT_IS_BOND; parameters[19].Value = model.MERCHANT_BOND; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Parking.Core.Model.PBA_MERCHANT_INFO DataRowToModel(DataRow row) { Parking.Core.Model.PBA_MERCHANT_INFO model = new Parking.Core.Model.PBA_MERCHANT_INFO(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["MERCHANT_NAME"] != null) { model.MERCHANT_NAME = row["MERCHANT_NAME"].ToString(); } if (row["MERCHANT_CORPORATION"] != null) { model.MERCHANT_CORPORATION = row["MERCHANT_CORPORATION"].ToString(); } if (row["MERCHANT_CERTIFICATE_NO"] != null) { model.MERCHANT_CERTIFICATE_NO = row["MERCHANT_CERTIFICATE_NO"].ToString(); } if (row["MERCHANT_LOGO"] != null) { model.MERCHANT_LOGO = row["MERCHANT_LOGO"].ToString(); } if (row["MERCHANT_ADDRESS"] != null) { model.MERCHANT_ADDRESS = row["MERCHANT_ADDRESS"].ToString(); } if (row["MERCHANT_TEL"] != null) { model.MERCHANT_TEL = row["MERCHANT_TEL"].ToString(); } if (row["MERCHANT_CONTACTS"] != null) { model.MERCHANT_CONTACTS = row["MERCHANT_CONTACTS"].ToString(); } if (row["MERCHANT_QQ"] != null) { model.MERCHANT_QQ = row["MERCHANT_QQ"].ToString(); } if (row["MERCHANT_WECHART"] != null) { model.MERCHANT_WECHART = row["MERCHANT_WECHART"].ToString(); } if (row["MERCHANT_PHONE"] != null) { model.MERCHANT_PHONE = row["MERCHANT_PHONE"].ToString(); } if (row["MERCHANT_ID_CARD"] != null) { model.MERCHANT_ID_CARD = row["MERCHANT_ID_CARD"].ToString(); } if (row["MERCHANT_TYPE"] != null && row["MERCHANT_TYPE"].ToString() != "") { model.MERCHANT_TYPE = int.Parse(row["MERCHANT_TYPE"].ToString()); } if (row["MERCHANT_NATURE"] != null && row["MERCHANT_NATURE"].ToString() != "") { model.MERCHANT_NATURE = int.Parse(row["MERCHANT_NATURE"].ToString()); } if (row["MERCHANT_REPUTATION_LEVEL"] != null && row["MERCHANT_REPUTATION_LEVEL"].ToString() != "") { model.MERCHANT_REPUTATION_LEVEL = int.Parse(row["MERCHANT_REPUTATION_LEVEL"].ToString()); } if (row["MERCHANT_ENABLE"] != null && row["MERCHANT_ENABLE"].ToString() != "") { model.MERCHANT_ENABLE = int.Parse(row["MERCHANT_ENABLE"].ToString()); } if (row["MERCHANT_CREATE_USER_NAME"] != null) { model.MERCHANT_CREATE_USER_NAME = row["MERCHANT_CREATE_USER_NAME"].ToString(); } if (row["MERCHANT_CREATE_TIME"] != null && row["MERCHANT_CREATE_TIME"].ToString() != "") { model.MERCHANT_CREATE_TIME = DateTime.Parse(row["MERCHANT_CREATE_TIME"].ToString()); } if (row["MERCHANT_IS_BOND"] != null && row["MERCHANT_IS_BOND"].ToString() != "") { model.MERCHANT_IS_BOND = int.Parse(row["MERCHANT_IS_BOND"].ToString()); } if (row["MERCHANT_BOND"] != null && row["MERCHANT_BOND"].ToString() != "") { model.MERCHANT_BOND = decimal.Parse(row["MERCHANT_BOND"].ToString()); } } return(model); }