/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(PresentProjectEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into PresentProject (" +
"ProjectName," +
"BeginDate," +
"EndDate," +
"MinMoney," +
"MaxMoney," +
"PresentContent," +
"Price," +
"PresentID," +
"Cash," +
"PresentExp," +
"PresentPoint," +
"IsDisabled) " +
"values(" +
"@ProjectName," +
"@BeginDate," +
"@EndDate," +
"@MinMoney," +
"@MaxMoney," +
"@PresentContent," +
"@Price," +
"@PresentID," +
"@Cash," +
"@PresentExp," +
"@PresentPoint," +
"@IsDisabled)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(DeliverChargeEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into DeliverCharge (" +
"DeliverTypeID," +
"AreaType," +
"arrArea," +
"Charge_Min," +
"Weight_Min," +
"ChargePerUnit," +
"WeightPerUnit," +
"Charge_Max) " +
"values(" +
"@DeliverTypeID," +
"@AreaType," +
"@arrArea," +
"@Charge_Min," +
"@Weight_Min," +
"@ChargePerUnit," +
"@WeightPerUnit," +
"@Charge_Max)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(PointLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into PointLog (" +
"UserName," +
"ModuleType," +
"InfoID," +
"Point," +
"LogTime," +
"Times," +
"IncomePayOut," +
"Remark," +
"IP," +
"Inputer," +
"Memo) " +
"values(" +
"@UserName," +
"@ModuleType," +
"@InfoID," +
"@Point," +
"@LogTime," +
"@Times," +
"@IncomePayOut," +
"@Remark," +
"@IP," +
"@Inputer," +
"@Memo)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(StatVisitEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into StatVisit (" +
"D1," +
"D2," +
"D3," +
"D4," +
"D5," +
"D6," +
"D7," +
"D8," +
"D9," +
"D10) " +
"values(" +
"@D1," +
"@D2," +
"@D3," +
"@D4," +
"@D5," +
"@D6," +
"@D7," +
"@D8," +
"@D9," +
"@D10)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(ValidLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into ValidLog (" +
"UserName," +
"ValidNum," +
"IncomePayout," +
"LogTime," +
"Remark," +
"IP," +
"Inputer," +
"Memo) " +
"values(" +
"@UserName," +
"@ValidNum," +
"@IncomePayout," +
"@LogTime," +
"@Remark," +
"@IP," +
"@Inputer," +
"@Memo)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(TransferLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into TransferLog (" +
"OrderID," +
"TransferTime," +
"OwnerUserName," +
"PayerUserName," +
"TargetUserName," +
"Poundage," +
"Inputer," +
"Remark) " +
"values(" +
"@OrderID," +
"@TransferTime," +
"@OwnerUserName," +
"@PayerUserName," +
"@TargetUserName," +
"@Poundage," +
"@Inputer," +
"@Remark)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(StatVisitorEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into StatVisitor (" +
"VTime," +
"Ip," +
"Address," +
"System," +
"Browser," +
"Screen," +
"Color," +
"Referer," +
"Timezone) " +
"values(" +
"@VTime," +
"@Ip," +
"@Address," +
"@System," +
"@Browser," +
"@Screen," +
"@Color," +
"@Referer," +
"@Timezone)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(RegionEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Region (" +
"Country," +
"Province," +
"City," +
"Area," +
"Area1," +
"Area2," +
"PostCode," +
"AreaCode) " +
"values(" +
"@Country," +
"@Province," +
"@City," +
"@Area," +
"@Area1," +
"@Area2," +
"@PostCode," +
"@AreaCode)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(SortingLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into SortingLog (" +
"Payer," +
"PaymentTime," +
"MoneyPay," +
"Status," +
"Operator," +
"OperatingTime," +
"Remark," +
"LogTime) " +
"values(" +
"@Payer," +
"@PaymentTime," +
"@MoneyPay," +
"@Status," +
"@Operator," +
"@OperatingTime," +
"@Remark," +
"@LogTime)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(PresentBuyLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into PresentBuyLog (" +
"ProductID," +
"UserID," +
"Msg," +
"IsSuccess," +
"NeedS," +
"UpdateTime," +
"BuyCounts) " +
"values(" +
"@ProductID," +
"@UserID," +
"@Msg," +
"@IsSuccess," +
"@NeedS," +
"@UpdateTime," +
"@BuyCounts)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(LogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Log (" +
"Category," +
"Priority," +
"Title," +
"Message," +
"Timestamp," +
"UserName," +
"UserIP," +
"Source," +
"ScriptName," +
"PostString) " +
"values(" +
"@Category," +
"@Priority," +
"@Title," +
"@Message," +
"@Timestamp," +
"@UserName," +
"@UserIP," +
"@Source," +
"@ScriptName," +
"@PostString)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(MentionLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into MentionLog (" +
"Applicant," +
"ApplicationTime," +
"ApplicationAmount," +
"HandlingCharge," +
"BankAccount," +
"MentionStatus," +
"Operator," +
"OperatingTime," +
"Remark," +
"LogTime) " +
"values(" +
"@Applicant," +
"@ApplicationTime," +
"@ApplicationAmount," +
"@HandlingCharge," +
"@BankAccount," +
"@MentionStatus," +
"@Operator," +
"@OperatingTime," +
"@Remark," +
"@LogTime)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(OrderFeedbackEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into OrderFeedback (" +
"OrderID," +
"UserName," +
"Content," +
"WriteTime," +
"ReplyName," +
"ReplyContent," +
"ReplyTime) " +
"values(" +
"@OrderID," +
"@UserName," +
"@Content," +
"@WriteTime," +
"@ReplyName," +
"@ReplyContent," +
"@ReplyTime)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(UserMessageEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into UserMessage (" +
"Title," +
"Content," +
"Sender," +
"Incept," +
"SendTime," +
"IsSend," +
"IsDelInbox," +
"IsDelSendbox," +
"IsRead) " +
"values(" +
"@Title," +
"@Content," +
"@Sender," +
"@Incept," +
"@SendTime," +
"@IsSend," +
"@IsDelInbox," +
"@IsDelSendbox," +
"@IsRead)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(CourierEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Courier (" +
"ShortName," +
"FullName," +
"Address," +
"Telephone," +
"Contacter," +
"SearchUrl," +
"SearchUrlMobile) " +
"values(" +
"@ShortName," +
"@FullName," +
"@Address," +
"@Telephone," +
"@Contacter," +
"@SearchUrl," +
"@SearchUrlMobile)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(DeliverLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into DeliverLog (" +
"OrderID," +
"DeliverDate," +
"DeliverDirection," +
"HandlerName," +
"CourierId," +
"ExpressNumber," +
"Inputer," +
"Remark," +
"IsReceived," +
"ReceivedDate," +
"Memo) " +
"values(" +
"@OrderID," +
"@DeliverDate," +
"@DeliverDirection," +
"@HandlerName," +
"@CourierId," +
"@ExpressNumber," +
"@Inputer," +
"@Remark," +
"@IsReceived," +
"@ReceivedDate," +
"@Memo)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(KeywordsEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Keywords (" +
"KeywordText," +
"KeywordType," +
"Priority," +
"Hits," +
"LastUseTime," +
"GeneralID," +
"QuoteTimes) " +
"values(" +
"@KeywordText," +
"@KeywordType," +
"@Priority," +
"@Hits," +
"@LastUseTime," +
"@GeneralID," +
"@QuoteTimes)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(HirePurchaseEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into HirePurchase (" +
"NodeID," +
"ProductID," +
"DownPayment," +
"DownPaymentMax," +
"YearRate," +
"Fee," +
"MerchantRebate," +
"Deadline," +
"MinLoanMoney," +
"MaxLoanMoney) " +
"values(" +
"@NodeID," +
"@ProductID," +
"@DownPayment," +
"@DownPaymentMax," +
"@YearRate," +
"@Fee," +
"@MerchantRebate," +
"@Deadline," +
"@MinLoanMoney," +
"@MaxLoanMoney)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(StockOutEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into StockOut (" +
"Email," +
"UserId," +
"Mobile," +
"ProductId," +
"OrderNum," +
"InputTime," +
"IP," +
"EmailStatus," +
"MobileStatus," +
"Property) " +
"values(" +
"@Email," +
"@UserId," +
"@Mobile," +
"@ProductId," +
"@OrderNum," +
"@InputTime," +
"@IP," +
"@EmailStatus," +
"@MobileStatus," +
"@Property)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(RepaymentEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Repayment (" +
"OrderID," +
"OrderItemID," +
"UserID," +
"Deadline," +
"CurrentDeadline," +
"RePayDate," +
"RePayMoney," +
"Principal," +
"Interest," +
"MonthFeeMoney," +
"VIPMoney," +
"InsuranceMoney," +
"RePayMoneySub," +
"RepaymentType," +
"RepaymentStatus," +
"TrueRePayDate," +
"TrueRePayMoney," +
"OverdueDays," +
"LateFee," +
"PressMoneyStatus," +
"PressMoneyStaff," +
"Remark," +
"Remark1," +
"Remark2) " +
"values(" +
"@OrderID," +
"@OrderItemID," +
"@UserID," +
"@Deadline," +
"@CurrentDeadline," +
"@RePayDate," +
"@RePayMoney," +
"@Principal," +
"@Interest," +
"@MonthFeeMoney," +
"@VIPMoney," +
"@InsuranceMoney," +
"@RePayMoneySub," +
"@RepaymentType," +
"@RepaymentStatus," +
"@TrueRePayDate," +
"@TrueRePayMoney," +
"@OverdueDays," +
"@LateFee," +
"@PressMoneyStatus," +
"@PressMoneyStaff," +
"@Remark," +
"@Remark1," +
"@Remark2)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(AuthorEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Author (" +
"UserID," +
"Type," +
"Name," +
"IsPassed," +
"IsTop," +
"IsElite," +
"Hits," +
"LastUseTime," +
"TemplateID," +
"AuthorPic," +
"AuthorIntro," +
"Address," +
"Tel," +
"Fax," +
"Mail," +
"Email," +
"ZipCode," +
"HomePage," +
"Im," +
"Sex," +
"BirthDay," +
"Company," +
"Department) " +
"values(" +
"@UserID," +
"@Type," +
"@Name," +
"@IsPassed," +
"@IsTop," +
"@IsElite," +
"@Hits," +
"@LastUseTime," +
"@TemplateID," +
"@AuthorPic," +
"@AuthorIntro," +
"@Address," +
"@Tel," +
"@Fax," +
"@Mail," +
"@Email," +
"@ZipCode," +
"@HomePage," +
"@Im," +
"@Sex," +
"@BirthDay," +
"@Company," +
"@Department)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(ProductDataEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into ProductData (" +
"ProductID," +
"TableName," +
"PropertyValue," +
"Stocks," +
"OrderNum," +
"AlarmNum," +
"BuyTimes," +
"Weight," +
"Volume," +
"Price," +
"Price_Market," +
"Price_Activity," +
"Price_Settlement," +
"Price_Member," +
"Price_Agent," +
"Price_Wholesale1," +
"Price_Wholesale2," +
"Price_Wholesale3," +
"Number_Wholesale1," +
"Number_Wholesale2," +
"Number_Wholesale3," +
"IsValid) " +
"values(" +
"@ProductID," +
"@TableName," +
"@PropertyValue," +
"@Stocks," +
"@OrderNum," +
"@AlarmNum," +
"@BuyTimes," +
"@Weight," +
"@Volume," +
"@Price," +
"@Price_Market," +
"@Price_Activity," +
"@Price_Settlement," +
"@Price_Member," +
"@Price_Agent," +
"@Price_Wholesale1," +
"@Price_Wholesale2," +
"@Price_Wholesale3," +
"@Number_Wholesale1," +
"@Number_Wholesale2," +
"@Number_Wholesale3," +
"@IsValid)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(MailListEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into MailList (" +
"Email) " +
"values(" +
"@Email)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(SubscriptionItemsEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into SubscriptionItems (" +
"Name) " +
"values(" +
"@Name)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(ServiceLogEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into ServiceLog (" +
"ClientID," +
"ContacterID," +
"OrderID," +
"ServiceTime," +
"ServiceType," +
"ServiceMode," +
"ServiceTitle," +
"ServiceContent," +
"ServiceResult," +
"TakeTime," +
"ServicePoint," +
"Processor," +
"Inputer," +
"Feedback," +
"ConfirmTime," +
"ConfirmCaller," +
"ConfirmScore," +
"ConfirmFeedback," +
"Remark) " +
"values(" +
"@ClientID," +
"@ContacterID," +
"@OrderID," +
"@ServiceTime," +
"@ServiceType," +
"@ServiceMode," +
"@ServiceTitle," +
"@ServiceContent," +
"@ServiceResult," +
"@TakeTime," +
"@ServicePoint," +
"@Processor," +
"@Inputer," +
"@Feedback," +
"@ConfirmTime," +
"@ConfirmCaller," +
"@ConfirmScore," +
"@ConfirmFeedback," +
"@Remark)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(KeywordRelationEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into KeywordRelation (" +
"KeywordID," +
"GeneralID) " +
"values(" +
"@KeywordID," +
"@GeneralID)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(SourceEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Source (" +
"Type," +
"Name," +
"IsPassed," +
"IsTop," +
"IsElite," +
"Hits," +
"LastUseTime," +
"Photo," +
"Intro," +
"Address," +
"Tel," +
"Fax," +
"Mail," +
"Email," +
"ZipCode," +
"HomePage," +
"Im," +
"Contacter) " +
"values(" +
"@Type," +
"@Name," +
"@IsPassed," +
"@IsTop," +
"@IsElite," +
"@Hits," +
"@LastUseTime," +
"@Photo," +
"@Intro," +
"@Address," +
"@Tel," +
"@Fax," +
"@Mail," +
"@Email," +
"@ZipCode," +
"@HomePage," +
"@Im," +
"@Contacter)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(FileRelationInfoEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into FileRelationInfo (" +
"InfoID," +
"InfoType," +
"Path) " +
"values(" +
"@InfoID," +
"@InfoType," +
"@Path)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(StatIpInfoEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into StatIpInfo (" +
"StartIp," +
"EndIp," +
"Address) " +
"values(" +
"@StartIp," +
"@EndIp," +
"@Address)";
return(_DB.ExeSQLResult(strSQL, dict));
}
/// <summary>
/// 增加一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual bool Add(DictionaryEntity entity)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Dictionary (" +
"Title," +
"TableName," +
"FieldName," +
"FieldValue) " +
"values(" +
"@Title," +
"@TableName," +
"@FieldName," +
"@FieldValue)";
return(_DB.ExeSQLResult(strSQL, dict));
}