/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Hi.Model.PAY_PrePayment GetModel(DataRow r)
{
Hi.Model.PAY_PrePayment model = new Hi.Model.PAY_PrePayment();
model.ID = SqlHelper.GetInt(r["ID"]);
model.CompID = SqlHelper.GetInt(r["CompID"]);
model.DisID = SqlHelper.GetInt(r["DisID"]);
model.OrderID = SqlHelper.GetInt(r["OrderID"]);
model.Start = SqlHelper.GetInt(r["Start"]);
model.PreType = SqlHelper.GetInt(r["PreType"]);
model.price = SqlHelper.GetDecimal(r["price"]);
model.CreatDate = SqlHelper.GetDateTime(r["CreatDate"]);
model.OldId = SqlHelper.GetInt(r["OldId"]);
model.CrateUser = SqlHelper.GetInt(r["CrateUser"]);
model.AuditState = SqlHelper.GetInt(r["AuditState"]);
model.AuditUser = SqlHelper.GetInt(r["AuditUser"]);
model.IsEnabled = SqlHelper.GetInt(r["IsEnabled"]);
model.AuditDate = SqlHelper.GetDateTime(r["AuditDate"]);
model.ts = SqlHelper.GetDateTime(r["ts"]);
model.dr = SqlHelper.GetInt(r["dr"]);
model.modifyuser = SqlHelper.GetInt(r["modifyuser"]);
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.Paytime = SqlHelper.GetDateTime(r["Paytime"]);
model.vdef6 = SqlHelper.GetString(r["vdef6"]);
model.guid = SqlHelper.GetString(r["guid"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.PAY_PrePayment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [PAY_PrePayment](");
strSql.Append("[CompID],[DisID],[OrderID],[Start],[PreType],[price],[CreatDate],[OldId],[CrateUser],[AuditState],[AuditUser],[IsEnabled],[AuditDate],[ts],[dr],[modifyuser],[vdef1],[vdef2],[vdef3],[vdef4],[vdef5],[Paytime],[vdef6],[guid])");
strSql.Append(" values (");
strSql.Append("@CompID,@DisID,@OrderID,@Start,@PreType,@price,@CreatDate,@OldId,@CrateUser,@AuditState,@AuditUser,@IsEnabled,@AuditDate,@ts,@dr,@modifyuser,@vdef1,@vdef2,@vdef3,@vdef4,@vdef5,@Paytime,@vdef6,@guid)");
strSql.Append(";select @@Identity");
SqlParameter[] parameters =
{
new SqlParameter("@CompID", SqlDbType.Int),
new SqlParameter("@DisID", SqlDbType.Int),
new SqlParameter("@OrderID", SqlDbType.BigInt),
new SqlParameter("@Start", SqlDbType.Int),
new SqlParameter("@PreType", SqlDbType.Int),
new SqlParameter("@price", SqlDbType.Decimal),
new SqlParameter("@CreatDate", SqlDbType.DateTime),
new SqlParameter("@OldId", SqlDbType.BigInt),
new SqlParameter("@CrateUser", SqlDbType.Int),
new SqlParameter("@AuditState", SqlDbType.Int),
new SqlParameter("@AuditUser", SqlDbType.Int),
new SqlParameter("@IsEnabled", SqlDbType.Int),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@dr", SqlDbType.SmallInt),
new SqlParameter("@modifyuser", SqlDbType.Int),
new SqlParameter("@vdef1", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef2", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef3", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef4", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef5", SqlDbType.VarChar, 2000),
new SqlParameter("@Paytime", SqlDbType.DateTime),
new SqlParameter("@vdef6", SqlDbType.VarChar, 200),
new SqlParameter("@guid", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.CompID;
parameters[1].Value = model.DisID;
parameters[2].Value = model.OrderID;
parameters[3].Value = model.Start;
parameters[4].Value = model.PreType;
parameters[5].Value = model.price;
parameters[6].Value = model.CreatDate;
parameters[7].Value = model.OldId;
parameters[8].Value = model.CrateUser;
parameters[9].Value = model.AuditState;
parameters[10].Value = model.AuditUser;
parameters[11].Value = model.IsEnabled;
if (model.AuditDate != DateTime.MinValue)
{
parameters[12].Value = model.AuditDate;
}
else
{
parameters[12].Value = DBNull.Value;
}
if (model.ts != DateTime.MinValue)
{
parameters[13].Value = model.ts;
}
else
{
parameters[13].Value = DBNull.Value;
}
parameters[14].Value = model.dr;
parameters[15].Value = model.modifyuser;
if (model.vdef1 != null)
{
parameters[16].Value = model.vdef1;
}
else
{
parameters[16].Value = DBNull.Value;
}
if (model.vdef2 != null)
{
parameters[17].Value = model.vdef2;
}
else
{
parameters[17].Value = DBNull.Value;
}
if (model.vdef3 != null)
{
parameters[18].Value = model.vdef3;
}
else
{
parameters[18].Value = DBNull.Value;
}
if (model.vdef4 != null)
{
parameters[19].Value = model.vdef4;
}
else
{
parameters[19].Value = DBNull.Value;
}
if (model.vdef5 != null)
{
parameters[20].Value = model.vdef5;
}
else
{
parameters[20].Value = DBNull.Value;
}
parameters[21].Value = model.Paytime;
if (model.vdef6 != null)
{
parameters[22].Value = model.vdef6;
}
else
{
parameters[22].Value = DBNull.Value;
}
if (model.guid != null)
{
parameters[23].Value = model.guid;
}
else
{
parameters[23].Value = DBNull.Value;
}
return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters)));
}
/// <summary>
/// 退款成功后，在企业钱包表中增加一条退款的企业钱包记录
/// </summary>
/// <param name="sqlconn"></param>
/// <param name="orderid"></param>
/// <param name="sqltans"></param>
/// <returns></returns>
public int InsertPrepay(SqlConnection sqlconn, Hi.Model.PAY_PrePayment model, SqlTransaction sqltans)
{
return(dal.InsertPrepay(sqlconn, model, sqltans));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.PAY_PrePayment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [PAY_PrePayment] set ");
strSql.Append("[CompID]=@CompID,");
strSql.Append("[DisID]=@DisID,");
strSql.Append("[OrderID]=@OrderID,");
strSql.Append("[Start]=@Start,");
strSql.Append("[PreType]=@PreType,");
strSql.Append("[price]=@price,");
strSql.Append("[CreatDate]=@CreatDate,");
strSql.Append("[OldId]=@OldId,");
strSql.Append("[CrateUser]=@CrateUser,");
strSql.Append("[AuditState]=@AuditState,");
strSql.Append("[AuditUser]=@AuditUser,");
strSql.Append("[IsEnabled]=@IsEnabled,");
strSql.Append("[AuditDate]=@AuditDate,");
strSql.Append("[ts]=@ts,");
strSql.Append("[dr]=@dr,");
strSql.Append("[modifyuser]=@modifyuser,");
strSql.Append("[vdef1]=@vdef1,");
strSql.Append("[vdef2]=@vdef2,");
strSql.Append("[vdef3]=@vdef3,");
strSql.Append("[vdef4]=@vdef4,");
strSql.Append("[vdef5]=@vdef5,");
strSql.Append("[Paytime]=@Paytime,");
strSql.Append("[vdef6]=@vdef6,");
strSql.Append("[guid]=@guid");
strSql.Append(" where [ID]=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt),
new SqlParameter("@CompID", SqlDbType.Int),
new SqlParameter("@DisID", SqlDbType.Int),
new SqlParameter("@OrderID", SqlDbType.BigInt),
new SqlParameter("@Start", SqlDbType.Int),
new SqlParameter("@PreType", SqlDbType.Int),
new SqlParameter("@price", SqlDbType.Decimal),
new SqlParameter("@CreatDate", SqlDbType.DateTime),
new SqlParameter("@OldId", SqlDbType.BigInt),
new SqlParameter("@CrateUser", SqlDbType.Int),
new SqlParameter("@AuditState", SqlDbType.Int),
new SqlParameter("@AuditUser", SqlDbType.Int),
new SqlParameter("@IsEnabled", SqlDbType.Int),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@dr", SqlDbType.SmallInt),
new SqlParameter("@modifyuser", SqlDbType.Int),
new SqlParameter("@vdef1", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef2", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef3", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef4", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef5", SqlDbType.VarChar, 2000),
new SqlParameter("@Paytime", SqlDbType.DateTime),
new SqlParameter("@vdef6", SqlDbType.VarChar, 200),
new SqlParameter("@guid", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.CompID;
parameters[2].Value = model.DisID;
parameters[3].Value = model.OrderID;
parameters[4].Value = model.Start;
parameters[5].Value = model.PreType;
parameters[6].Value = model.price;
parameters[7].Value = model.CreatDate;
parameters[8].Value = model.OldId;
parameters[9].Value = model.CrateUser;
parameters[10].Value = model.AuditState;
parameters[11].Value = model.AuditUser;
parameters[12].Value = model.IsEnabled;
if (model.AuditDate != DateTime.MinValue)
{
parameters[13].Value = model.AuditDate;
}
else
{
parameters[13].Value = DBNull.Value;
}
if (model.ts != DateTime.MinValue)
{
parameters[14].Value = model.ts;
}
else
{
parameters[14].Value = DBNull.Value;
}
parameters[15].Value = model.dr;
parameters[16].Value = model.modifyuser;
if (model.vdef1 != null)
{
parameters[17].Value = model.vdef1;
}
else
{
parameters[17].Value = DBNull.Value;
}
if (model.vdef2 != null)
{
parameters[18].Value = model.vdef2;
}
else
{
parameters[18].Value = DBNull.Value;
}
if (model.vdef3 != null)
{
parameters[19].Value = model.vdef3;
}
else
{
parameters[19].Value = DBNull.Value;
}
if (model.vdef4 != null)
{
parameters[20].Value = model.vdef4;
}
else
{
parameters[20].Value = DBNull.Value;
}
if (model.vdef5 != null)
{
parameters[21].Value = model.vdef5;
}
else
{
parameters[21].Value = DBNull.Value;
}
parameters[22].Value = model.Paytime;
if (model.vdef6 != null)
{
parameters[23].Value = model.vdef6;
}
else
{
parameters[23].Value = DBNull.Value;
}
if (model.guid != null)
{
parameters[24].Value = model.guid;
}
else
{
parameters[24].Value = DBNull.Value;
}
return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0);
}
/// <summary>
/// 退款成功后，在企业钱包表中增加一条退款的企业钱包记录
/// </summary>
/// <param name="sqlconn"></param>
/// <param name="orderid"></param>
/// <param name="sqltans"></param>
/// <returns></returns>
public int InsertPrepay(SqlConnection sqlconn, Hi.Model.PAY_PrePayment model, SqlTransaction sqltans)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [PAY_PrePayment](");
strSql.Append("[CompID],[DisID],[OrderID],[Start],[PreType],[price],[CreatDate],[OldId],[CrateUser],[AuditState],[AuditUser],[IsEnabled],[AuditDate],[ts],[dr],[modifyuser],[vdef1],[vdef2],[vdef3],[vdef4],[vdef5],[Paytime])");
strSql.Append(" values (");
strSql.Append("@CompID,@DisID,@OrderID,@Start,@PreType,@price,@CreatDate,@OldId,@CrateUser,@AuditState,@AuditUser,@IsEnabled,@AuditDate,@ts,@dr,@modifyuser,@vdef1,@vdef2,@vdef3,@vdef4,@vdef5,@Paytime)");
strSql.Append(";select @@Identity");
SqlParameter[] parameters =
{
new SqlParameter("@CompID", SqlDbType.Int),
new SqlParameter("@DisID", SqlDbType.Int),
new SqlParameter("@OrderID", SqlDbType.BigInt),
new SqlParameter("@Start", SqlDbType.Int),
new SqlParameter("@PreType", SqlDbType.Int),
new SqlParameter("@price", SqlDbType.Decimal),
new SqlParameter("@CreatDate", SqlDbType.DateTime),
new SqlParameter("@OldId", SqlDbType.BigInt),
new SqlParameter("@CrateUser", SqlDbType.Int),
new SqlParameter("@AuditState", SqlDbType.Int),
new SqlParameter("@AuditUser", SqlDbType.Int),
new SqlParameter("@IsEnabled", SqlDbType.Int),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@dr", SqlDbType.SmallInt),
new SqlParameter("@modifyuser", SqlDbType.Int),
new SqlParameter("@vdef1", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef2", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef3", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef4", SqlDbType.NVarChar, 128),
new SqlParameter("@vdef5", SqlDbType.NVarChar, 128),
new SqlParameter("@Paytime", SqlDbType.DateTime)
};
SqlCommand cmd = new SqlCommand(strSql.ToString(), sqlconn, sqltans);
cmd.CommandType = CommandType.Text;
parameters[0].Value = model.CompID;
parameters[1].Value = model.DisID;
parameters[2].Value = model.OrderID;
parameters[3].Value = model.Start;
parameters[4].Value = model.PreType;
parameters[5].Value = model.price;
parameters[6].Value = model.CreatDate;
parameters[7].Value = model.OldId;
parameters[8].Value = model.CrateUser;
parameters[9].Value = model.AuditState;
parameters[10].Value = model.AuditUser;
parameters[11].Value = model.IsEnabled;
if (model.AuditDate != DateTime.MinValue)
{
parameters[12].Value = model.AuditDate;
}
else
{
parameters[12].Value = DBNull.Value;
}
if (model.ts != DateTime.MinValue)
{
parameters[13].Value = model.ts;
}
else
{
parameters[13].Value = DBNull.Value;
}
parameters[14].Value = model.dr;
parameters[15].Value = model.modifyuser;
if (model.vdef1 != null)
{
parameters[16].Value = model.vdef1;
}
else
{
parameters[16].Value = DBNull.Value;
}
if (model.vdef2 != null)
{
parameters[17].Value = model.vdef2;
}
else
{
parameters[17].Value = DBNull.Value;
}
if (model.vdef3 != null)
{
parameters[18].Value = model.vdef3;
}
else
{
parameters[18].Value = DBNull.Value;
}
if (model.vdef4 != null)
{
parameters[19].Value = model.vdef4;
}
else
{
parameters[19].Value = DBNull.Value;
}
if (model.vdef5 != null)
{
parameters[20].Value = model.vdef5;
}
else
{
parameters[20].Value = DBNull.Value;
}
parameters[21].Value = model.Paytime;
//SqlHelper.GetInt(cmd.ExecuteNonQuery().ToString());
int rowsAffected = SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters));
if (rowsAffected > 0)
{
return(rowsAffected);
}
else
{
return(0);
}
}
