/// <summary>
/// 更新订单信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateMSProductOrder(MSProductOrder model)
{
string safeslq = string.Empty;
safeslq = "UPDATE MS_ProductOrder SET ";
if (model.CartID != null && model.CartID != "")
{
safeslq += "CarID='" + model.CartID + "',";
}
if (model.CustomerID != null && model.CustomerID != "")
{
safeslq += "CustomerID='" + model.CustomerID + "',";
}
if (model.BuyName != null && model.BuyName.ToString() != "")
{
safeslq += "BuyName='" + model.BuyName + "',";
}
if (model.Phone != null && model.Phone.ToString() != "")
{
safeslq += "Phone='" + model.Phone + "',";
}
if (model.LeaveMsg != null && model.LeaveMsg != "")
{
safeslq += "LeaveMsg='" + model.LeaveMsg + "',";
}
if (model.PayWay != null && model.PayWay != "")
{
safeslq += "PayWay='" + model.PayWay + "',";
}
if (model.CarryWay != null && model.CarryWay != "")
{
safeslq += "CarryWay='" + model.CarryWay + "',";
}
if (model.ReveiveAddress != null && model.ReveiveAddress != "")
{
safeslq += "ReveiveAddress='" + model.ReveiveAddress + "',";
}
if (model.ZipCode != null && model.ZipCode != "")
{
safeslq += "ZipCode='" + model.ZipCode + "',";
}
safeslq += " IsSend=" + (model.IsSend == 1 ? 1 : 0) + ", ";
safeslq += " IsReceive=" + (model.IsReceive == 1 ? 1 : 0) + ", ";
safeslq += " OrderState=" + (model.OrderState == 1 ? 1 : 0) + ", ";
safeslq += " PayState=" + (model.PayState == 1 ? 1 : 0) + " ";
safeslq += " where ID='" + model.ID + "' ";
int rowsAffected = DbHelperSQL.ExecuteSql(safeslq.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加订单
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddMSProductOrder(MSProductOrder model)
{
string sql = @"INSERT INTO [MS_ProductOrder]
([ID],[CartID],[CustomerID],[BuyName],[Phone],[LeaveMsg],[PayWay],[CarryWay],[ReveiveAddress],
[ZipCode],[IsSend],[IsReceive],[OrderState],[PayState],[PayTime],[AddTime])
VALUES
(@ID,@CartID,@CustomerID,@BuyName,@Phone,@LeaveMsg,@PayWay,@CarryWay,@ReveiveAddress,
@ZipCode,@IsSend,@IsReceive,@OrderState,@PayState,@PayTime,@AddTime)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@CartID", model.CartID),
new System.Data.SqlClient.SqlParameter("@CustomerID", model.CustomerID),
new System.Data.SqlClient.SqlParameter("@BuyName", model.BuyName),
new System.Data.SqlClient.SqlParameter("@Phone", model.Phone),
new System.Data.SqlClient.SqlParameter("@LeaveMsg", model.LeaveMsg),
new System.Data.SqlClient.SqlParameter("@PayWay", model.PayWay),
new System.Data.SqlClient.SqlParameter("@CarryWay", model.CarryWay),
new System.Data.SqlClient.SqlParameter("@ReveiveAddress", model.ReveiveAddress),
new System.Data.SqlClient.SqlParameter("@ZipCode", model.ZipCode),
new System.Data.SqlClient.SqlParameter("@IsSend", model.IsSend == 1?1:0),
new System.Data.SqlClient.SqlParameter("@IsReceive", model.IsReceive == 1?1:0),
new System.Data.SqlClient.SqlParameter("@OrderState", model.OrderState == 1?1:0),
new System.Data.SqlClient.SqlParameter("@PayState", (model.PayState == 1?1:0)),
new System.Data.SqlClient.SqlParameter("@PayTime", model.PayTime),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now)
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
