/// <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);
}
