public bool UpdatePrepayIdById(string prepayId, decimal orderId)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
string strSql = "update AdvanceParking set PrepayId=@PrepayId where OrderId=@OrderId";
dbOperator.AddParameter("OrderId", orderId);
dbOperator.AddParameter("PrepayId", prepayId);
return(dbOperator.ExecuteNonQuery(strSql) > 0);
}
}
public bool PaySuccess(decimal orderId, string serialNumber, DateTime payTime, DbOperator dbOperator)
{
string strSql = "update AdvanceParking set PayTime=@PayTime,SerialNumber=@SerialNumber,OrderState=@OrderState where OrderId=@OrderId";
dbOperator.AddParameter("OrderId", orderId);
dbOperator.AddParameter("OrderState", 1);
dbOperator.AddParameter("SerialNumber", serialNumber);
dbOperator.AddParameter("PayTime", payTime);
return(dbOperator.ExecuteNonQuery(strSql) > 0);
}
public int DeleteCompanyGroup(Guid company, Guid companyGroup)
{
string sql = "DELETE FROM [T_CompanyGroup] WHERE [Company]=@Company AND [Id]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Company", company);
dbOperator.AddParameter("Id", companyGroup);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int Delete(int[] id)
{
string str_ids = DomainService.GetIds(id);
string sql = @"DETELE FROM Operations WHERE id in (" + str_ids + " )";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
return(dbOperator.ExecuteNonQuery(sql));
}
}
public void Delete(Guid permissionRole)
{
string sql = "DELETE FROM dbo.T_PermissionRole WHERE [Id]=@ID;" +
"DELETE FROM dbo.[T_RolePermission] WHERE [Role]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", permissionRole);
dbOperator.ExecuteNonQuery(sql);
}
}
public void Delete(Guid styleId)
{
const string sql = "DELETE FROM T_OEMStyle WHERE Id=@Id;delete from t_OEMStyleFile where OEMStyleId =@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Id", styleId);
dbOperator.ExecuteNonQuery(sql);
}
}
public int UpdateAreaRelation(Guid area, string provinceCode)
{
string sql = "UPDATE [dbo].[T_SellAreaRelation] SET [Area]=@Area WHERE [Province]=@Province";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Area", area);
dbOperator.AddParameter("Province", provinceCode);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int DeleteItem(SystemDictionaryType type, Guid id)
{
string sql = "DELETE FROM [T_SystemDictionary] WHERE [TYPE]=@TYPE AND [ID]=@ID";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("TYPE", (int)type);
dbOperator.AddParameter("ID", id);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int Delete(Guid detailId)
{
string sql = @"DELETE FROM [dbo].[T_RefundAndReschedulingDetail] WHERE Id=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("@Id", detailId);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int Update(Guid id, bool enabled)
{
string sql = "UPDATE [T_VIPManagement] SET [IsVip]=@IsVip WHERE [Id]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("IsVip", enabled);
dbOperator.AddParameter("Id", id);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int Delete(UpperString airlineCode)
{
string sql = "DELETE FROM [T_RefundAndReschedulingBase] WHERE [Airline]=@Airline";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Airline", airlineCode.Value);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public bool UpdatePayAccount(decimal orderId, string payAccount)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
string strSql = "update OnlineOrder set PayAccount=@PayAccount,Payer=@PayAccount where OrderId=@OrderId";
dbOperator.AddParameter("OrderId", orderId);
dbOperator.AddParameter("PayAccount", payAccount);
return(dbOperator.ExecuteNonQuery(strSql) > 0);
}
}
public bool UpdateSFMCode(string code, decimal orderId)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
string strSql = "update OnlineOrder set InOutID=@InOutID where OrderId=@OrderId";
dbOperator.AddParameter("OrderId", orderId);
dbOperator.AddParameter("InOutID", code);
return(dbOperator.ExecuteNonQuery(strSql) > 0);
}
}
public bool UpdateOrderStatusByIORecordIds(List <string> recordIds, int status, DbOperator dbOperator)
{
string strSql = string.Format(@"update ParkOrder set Status=@Status,HaveUpdate=@HaveUpdate,LastUpdateTime=@LastUpdateTime where TagID in('{0}');", string.Join("','", recordIds));
dbOperator.ClearParameters();
dbOperator.AddParameter("Status", status);
dbOperator.AddParameter("HaveUpdate", SystemDefaultConfig.DataUpdateFlag);
dbOperator.AddParameter("LastUpdateTime", DateTime.Now);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
public bool UpdateReplyType(int id, ReplyType type, DbOperator dbOperator)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WX_Keyword set ReplyType=@ReplyType where ID=@ID");
dbOperator.ClearParameters();
dbOperator.AddParameter("ReplyType", (int)type);
dbOperator.AddParameter("ID", id);
return(dbOperator.ExecuteNonQuery(strSql.ToString()) > 0);
}
public int Update(SystemParamType type, string value)
{
string sql = "UPDATE [T_SystemParam] SET [VALUE]=@VALUE WHERE [ID]=@ID";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", (int)type);
dbOperator.AddParameter("VALUE", value);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int UpdateStatus(Guid id, AduiteStatus status)
{
string sql = "UPDATE [dbo].[T_Announce] SET [AduiteStatus]=@Status WHERE [Id]=@Id";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("Status", (int)status);
dbOperator.AddParameter("Id", id);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public void Update(RefundFailedRecord record)
{
var sql = "INSERT INTO dbo.T_RefundFailedInfo ErrorMsg=@ErrorMsg WHERE ApplyformId=@ApplyformId";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ApplyformId", record.ApplyformId);
dbOperator.AddParameter("ErrorMsg", record.RefundFailedInfo);
dbOperator.ExecuteNonQuery(sql);
}
}
public bool PaySuccess(decimal orderId, string serialNumber, DateTime payTime, DbOperator dbOperator)
{
string strSql = "update OnlineOrder set RealPayTime=@RealPayTime,SerialNumber=@SerialNumber,Status=@Status where OrderId=@OrderId";
dbOperator.AddParameter("OrderId", orderId);
dbOperator.AddParameter("Status", (int)OnlineOrderStatus.PaySuccess);
dbOperator.AddParameter("SerialNumber", serialNumber);
dbOperator.AddParameter("RealPayTime", payTime);
return(dbOperator.ExecuteNonQuery(strSql) > 0);
}
public void UpdateStatus(Guid permissionRole, bool enabled)
{
string sql = "UPDATE dbo.T_PermissionRole SET [Valid]=@VALID WHERE [Id]=@ID";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", permissionRole);
dbOperator.AddParameter("VALID", enabled);
dbOperator.ExecuteNonQuery(sql);
}
}
public bool RefundFail(decimal orderId)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
string strSql = "update OnlineOrder set Status=@Status where OrderId=@OrderId";
dbOperator.AddParameter("OrderId", orderId);
dbOperator.AddParameter("Status", (int)OnlineOrderStatus.RefundFail);
return(dbOperator.ExecuteNonQuery(strSql) > 0);
}
}
public void Delete(Guid id)
{
string sql = @"DELETE FROM dbo.T_ReleaseNote WHERE Id=@Id";
using (DbOperator dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Id", id);
dbOperator.ExecuteNonQuery(sql);
}
}
public int Delete(Guid companyId, Guid customer)
{
string sql = "DELETE FROM dbo.T_Customer WHERE Id=@ID AND Company=@COMPANY";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("COMPANY", companyId);
dbOperator.AddParameter("ID", customer);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public void Delete(Guid id)
{
string sql = "DELETE FROM T_CompanyDrawCondition WHERE ID=@ID;";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("ID", id);
dbOperator.ExecuteNonQuery(sql);
}
}
public bool UpdateOrderSerialNumber(decimal orderId, string serialNumber)
{
using (DbOperator dbOperator = ConnectionManager.CreateConnection())
{
string strSql = "update AdvanceParking set SerialNumber=@SerialNumber where OrderId=@OrderId";
dbOperator.AddParameter("OrderId", orderId);
dbOperator.AddParameter("SerialNumber", serialNumber);
return(dbOperator.ExecuteNonQuery(strSql) > 0);
}
}
public int Delete(Guid companyId)
{
string sql = "DELETE FROM dbo.T_CompanyDocument WHERE Company = @Company";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Company", companyId);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int Insert(DataTransferObject.Foundation.FixedNavigationView value)
{
string sql = "INSERT INTO [T_FixedNavigation]([Departure],[Arrival]) VALUES(@Departure,@Arrival)";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("Departure", value.Departure);
dbOperator.AddParameter("Arrival", value.Arrival);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int SetSingleIpLimitation(Guid employeeId, string ipLimitation)
{
string sql = "UPDATE dbo.T_Employee SET IpLimitation=@IpLimitation WHERE [Id]=@EmployeeId";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("IpLimitation", ipLimitation);
dbOperator.AddParameter("EmployeeId", employeeId);
return(dbOperator.ExecuteNonQuery(sql));
}
}
public int Delete(DataTransferObject.Foundation.FixedNavigationView value)
{
string sql = "DELETE FROM [T_FixedNavigation] WHERE [Departure]=@Departure AND [Arrival]=@Arrival";
using (var dbOperate = new DbOperator(Provider, ConnectionString))
{
dbOperate.AddParameter("Departure", value.Departure);
dbOperate.AddParameter("Arrival", value.Arrival);
return(dbOperate.ExecuteNonQuery(sql));
}
}
public int SetAllIpLimitation(Guid companyId, string ipLimitation)
{
string sql = "UPDATE dbo.T_Employee SET IpLimitation=@IpLimitation WHERE [Owner]=@CompanyId";
using (var dbOperator = new DbOperator(Provider, ConnectionString))
{
dbOperator.AddParameter("IpLimitation", ipLimitation);
dbOperator.AddParameter("CompanyId", companyId);
return(dbOperator.ExecuteNonQuery(sql));
}
}
