/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.BD_PrePayment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [BD_PrePayment](");
strSql.Append("[CompID],[DisID],[OrderID],[Start],[PreType],[Money],[CreatDate],[OldId],[CrateUser],[AuditState],[AuditUser],[IsEnabled],[AuditDate],[ts],[modifyuser])");
strSql.Append(" values (");
strSql.Append("@CompID,@DisID,@OrderID,@Start,@PreType,@Money,@CreatDate,@OldId,@CrateUser,@AuditState,@AuditUser,@IsEnabled,@AuditDate,@ts,@modifyuser)");
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("@Money", 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.VarChar,50),
new SqlParameter("@IsEnabled", SqlDbType.Int),
new SqlParameter("@AuditDate", SqlDbType.DateTime),
new SqlParameter("@ts", SqlDbType.DateTime),
new SqlParameter("@modifyuser", SqlDbType.Int)
};
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.Money;
if (model.CreatDate != DateTime.MinValue)
{
parameters[6].Value = model.CreatDate;
}
else
{
parameters[6].Value = DBNull.Value;
}
parameters[7].Value = model.OldId;
parameters[8].Value = model.CrateUser;
parameters[9].Value = model.AuditState;
if (model.AuditUser != null)
{
parameters[10].Value = model.AuditUser;
}
else
{
parameters[10].Value = DBNull.Value;
}
parameters[11].Value = model.IsEnabled;
if (model.AuditDate != DateTime.MinValue)
{
parameters[12].Value = model.AuditDate;
}
else
{
parameters[12].Value = DBNull.Value;
}
parameters[13].Value = model.ts;
parameters[14].Value = model.modifyuser;
return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters)));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.BD_PrePayment model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [BD_PrePayment] set ");
strSql.Append("[CompID]=@CompID,");
strSql.Append("[DisID]=@DisID,");
strSql.Append("[OrderID]=@OrderID,");
strSql.Append("[Start]=@Start,");
strSql.Append("[PreType]=@PreType,");
strSql.Append("[Money]=@Money,");
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(" 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("@Money", 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.VarChar,50),
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)
};
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.Money;
if (model.CreatDate != DateTime.MinValue)
{
parameters[7].Value = model.CreatDate;
}
else
{
parameters[7].Value = DBNull.Value;
}
parameters[8].Value = model.OldId;
parameters[9].Value = model.CrateUser;
parameters[10].Value = model.AuditState;
if (model.AuditUser != null)
{
parameters[11].Value = model.AuditUser;
}
else
{
parameters[11].Value = DBNull.Value;
}
parameters[12].Value = model.IsEnabled;
if (model.AuditDate != DateTime.MinValue)
{
parameters[13].Value = model.AuditDate;
}
else
{
parameters[13].Value = DBNull.Value;
}
parameters[14].Value = model.ts;
parameters[15].Value = model.dr;
parameters[16].Value = model.modifyuser;
return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0);
}
