/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ApplyForBindMerModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ApplyForBindMer(");
strSql.Append("OrganizationNo,Tell,qq,BusinessImgId,email,Memo,BindUserId,BindMerchantId,CreateTime,Status,ContactName,OrganizationName,BusinessNo,LegalName");
strSql.Append(") values (");
strSql.Append("@OrganizationNo,@Tell,@qq,@BusinessImgId,@email,@Memo,@BindUserId,@BindMerchantId,@CreateTime,@Status,@ContactName,@OrganizationName,@BusinessNo,@LegalName");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@OrganizationNo", SqlDbType.VarChar, 50),
new SqlParameter("@Tell", SqlDbType.VarChar, 50),
new SqlParameter("@qq", SqlDbType.VarChar, 50),
new SqlParameter("@BusinessImgId", SqlDbType.VarChar, 50),
new SqlParameter("@email", SqlDbType.VarChar, 50),
new SqlParameter("@Memo", SqlDbType.VarChar, 1000),
new SqlParameter("@BindUserId", SqlDbType.VarChar, 50),
new SqlParameter("@BindMerchantId", SqlDbType.Decimal, 9),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@ContactName", SqlDbType.VarChar, 50),
new SqlParameter("@OrganizationName", SqlDbType.VarChar, 50),
new SqlParameter("@BusinessNo", SqlDbType.VarChar, 50),
new SqlParameter("@LegalName", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.OrganizationNo;
parameters[1].Value = model.Tell;
parameters[2].Value = model.qq;
parameters[3].Value = model.BusinessImgId;
parameters[4].Value = model.email;
parameters[5].Value = model.Memo;
parameters[6].Value = model.BindUserId;
parameters[7].Value = model.BindMerchantId;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.Status;
parameters[10].Value = model.ContactName;
parameters[11].Value = model.OrganizationName;
parameters[12].Value = model.BusinessNo;
parameters[13].Value = model.LegalName;
bool result = false;
try
{
helper.ExecSqlReInt(strSql.ToString(), parameters);
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ApplyForBindMerModel GetModel(decimal AutoId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AutoId, OrganizationNo, Tell, qq, BusinessImgId, email, Memo, BindUserId, BindMerchantId, CreateTime, Status, ContactName, OrganizationName, BusinessNo, LegalName ");
strSql.Append(" from ApplyForBindMer ");
strSql.Append(" where AutoId=@AutoId");
SqlParameter[] parameters =
{
new SqlParameter("@AutoId", SqlDbType.Decimal)
};
parameters[0].Value = AutoId;
ApplyForBindMerModel model = new ApplyForBindMerModel();
DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["AutoId"].ToString() != "")
{
model.AutoId = decimal.Parse(ds.Tables[0].Rows[0]["AutoId"].ToString());
}
model.OrganizationNo = ds.Tables[0].Rows[0]["OrganizationNo"].ToString();
model.Tell = ds.Tables[0].Rows[0]["Tell"].ToString();
model.qq = ds.Tables[0].Rows[0]["qq"].ToString();
model.BusinessImgId = ds.Tables[0].Rows[0]["BusinessImgId"].ToString();
model.email = ds.Tables[0].Rows[0]["email"].ToString();
model.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
model.BindUserId = ds.Tables[0].Rows[0]["BindUserId"].ToString();
if (ds.Tables[0].Rows[0]["BindMerchantId"].ToString() != "")
{
model.BindMerchantId = decimal.Parse(ds.Tables[0].Rows[0]["BindMerchantId"].ToString());
}
if (ds.Tables[0].Rows[0]["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
model.ContactName = ds.Tables[0].Rows[0]["ContactName"].ToString();
model.OrganizationName = ds.Tables[0].Rows[0]["OrganizationName"].ToString();
model.BusinessNo = ds.Tables[0].Rows[0]["BusinessNo"].ToString();
model.LegalName = ds.Tables[0].Rows[0]["LegalName"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ApplyForBindMerModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update ApplyForBindMer set ");
strSql.Append(" OrganizationNo = @OrganizationNo , ");
strSql.Append(" Tell = @Tell , ");
strSql.Append(" qq = @qq , ");
strSql.Append(" BusinessImgId = @BusinessImgId , ");
strSql.Append(" email = @email , ");
strSql.Append(" Memo = @Memo , ");
strSql.Append(" BindUserId = @BindUserId , ");
strSql.Append(" BindMerchantId = @BindMerchantId , ");
strSql.Append(" CreateTime = @CreateTime , ");
strSql.Append(" Status = @Status , ");
strSql.Append(" ContactName = @ContactName , ");
strSql.Append(" OrganizationName = @OrganizationName , ");
strSql.Append(" BusinessNo = @BusinessNo , ");
strSql.Append(" LegalName = @LegalName ");
strSql.Append(" where AutoId=@AutoId ");
SqlParameter[] parameters =
{
new SqlParameter("@AutoId", SqlDbType.Decimal, 9),
new SqlParameter("@OrganizationNo", SqlDbType.VarChar, 50),
new SqlParameter("@Tell", SqlDbType.VarChar, 50),
new SqlParameter("@qq", SqlDbType.VarChar, 50),
new SqlParameter("@BusinessImgId", SqlDbType.VarChar, 50),
new SqlParameter("@email", SqlDbType.VarChar, 50),
new SqlParameter("@Memo", SqlDbType.VarChar, 1000),
new SqlParameter("@BindUserId", SqlDbType.VarChar, 50),
new SqlParameter("@BindMerchantId", SqlDbType.Decimal, 9),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@ContactName", SqlDbType.VarChar, 50),
new SqlParameter("@OrganizationName", SqlDbType.VarChar, 50),
new SqlParameter("@BusinessNo", SqlDbType.VarChar, 50),
new SqlParameter("@LegalName", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.AutoId;
parameters[1].Value = model.OrganizationNo;
parameters[2].Value = model.Tell;
parameters[3].Value = model.qq;
parameters[4].Value = model.BusinessImgId;
parameters[5].Value = model.email;
parameters[6].Value = model.Memo;
parameters[7].Value = model.BindUserId;
parameters[8].Value = model.BindMerchantId;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.Status;
parameters[11].Value = model.ContactName;
parameters[12].Value = model.OrganizationName;
parameters[13].Value = model.BusinessNo;
parameters[14].Value = model.LegalName; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
