/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Hi.Model.PAY_BankInfo GetModel(DataRow r)
{
Hi.Model.PAY_BankInfo model = new Hi.Model.PAY_BankInfo();
model.Id = SqlHelper.GetInt(r["Id"]);
model.BankName = SqlHelper.GetString(r["BankName"]);
model.BankCode = SqlHelper.GetString(r["BankCode"]);
model.vdef1 = SqlHelper.GetString(r["vdef1"]);
model.vdef2 = SqlHelper.GetString(r["vdef2"]);
model.vdef3 = SqlHelper.GetString(r["vdef3"]);
model.vdef4 = SqlHelper.GetString(r["vdef4"]);
model.vdef5 = SqlHelper.GetString(r["vdef5"]);
model.vdef6 = SqlHelper.GetString(r["vdef6"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.PAY_BankInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [PAY_BankInfo](");
strSql.Append("[BankName],[BankCode],[vdef1],[vdef2],[vdef3],[vdef4],[vdef5],[vdef6])");
strSql.Append(" values (");
strSql.Append("@BankName,@BankCode,@vdef1,@vdef2,@vdef3,@vdef4,@vdef5,@vdef6)");
strSql.Append(";select @@Identity");
SqlParameter[] parameters =
{
new SqlParameter("@BankName", SqlDbType.NVarChar, 50),
new SqlParameter("@BankCode", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef1", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef2", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef3", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef4", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef5", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef6", SqlDbType.NVarChar, 50)
};
if (model.BankName != null)
{
parameters[0].Value = model.BankName;
}
else
{
parameters[0].Value = DBNull.Value;
}
if (model.BankCode != null)
{
parameters[1].Value = model.BankCode;
}
else
{
parameters[1].Value = DBNull.Value;
}
if (model.vdef1 != null)
{
parameters[2].Value = model.vdef1;
}
else
{
parameters[2].Value = DBNull.Value;
}
if (model.vdef2 != null)
{
parameters[3].Value = model.vdef2;
}
else
{
parameters[3].Value = DBNull.Value;
}
if (model.vdef3 != null)
{
parameters[4].Value = model.vdef3;
}
else
{
parameters[4].Value = DBNull.Value;
}
if (model.vdef4 != null)
{
parameters[5].Value = model.vdef4;
}
else
{
parameters[5].Value = DBNull.Value;
}
if (model.vdef5 != null)
{
parameters[6].Value = model.vdef5;
}
else
{
parameters[6].Value = DBNull.Value;
}
if (model.vdef6 != null)
{
parameters[7].Value = model.vdef6;
}
else
{
parameters[7].Value = DBNull.Value;
}
return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters)));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.PAY_BankInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [PAY_BankInfo] set ");
strSql.Append("[BankName]=@BankName,");
strSql.Append("[BankCode]=@BankCode,");
strSql.Append("[vdef1]=@vdef1,");
strSql.Append("[vdef2]=@vdef2,");
strSql.Append("[vdef3]=@vdef3,");
strSql.Append("[vdef4]=@vdef4,");
strSql.Append("[vdef5]=@vdef5,");
strSql.Append("[vdef6]=@vdef6");
strSql.Append(" where [Id]=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int),
new SqlParameter("@BankName", SqlDbType.NVarChar, 50),
new SqlParameter("@BankCode", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef1", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef2", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef3", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef4", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef5", SqlDbType.NVarChar, 50),
new SqlParameter("@vdef6", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Id;
if (model.BankName != null)
{
parameters[1].Value = model.BankName;
}
else
{
parameters[1].Value = DBNull.Value;
}
if (model.BankCode != null)
{
parameters[2].Value = model.BankCode;
}
else
{
parameters[2].Value = DBNull.Value;
}
if (model.vdef1 != null)
{
parameters[3].Value = model.vdef1;
}
else
{
parameters[3].Value = DBNull.Value;
}
if (model.vdef2 != null)
{
parameters[4].Value = model.vdef2;
}
else
{
parameters[4].Value = DBNull.Value;
}
if (model.vdef3 != null)
{
parameters[5].Value = model.vdef3;
}
else
{
parameters[5].Value = DBNull.Value;
}
if (model.vdef4 != null)
{
parameters[6].Value = model.vdef4;
}
else
{
parameters[6].Value = DBNull.Value;
}
if (model.vdef5 != null)
{
parameters[7].Value = model.vdef5;
}
else
{
parameters[7].Value = DBNull.Value;
}
if (model.vdef6 != null)
{
parameters[8].Value = model.vdef6;
}
else
{
parameters[8].Value = DBNull.Value;
}
return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0);
}
