/// <summary>
/// 设置销售信用度
/// </summary>
private void SetCashcredit()
{
lgk.Model.Cashcredit cashcreditInfo = new lgk.Model.Cashcredit();
if (cashcreditBLL.Exists("UserID=" + LoginUser.UserID + ""))
{
cashcreditInfo = cashcreditBLL.GetModel("UserID=" + LoginUser.UserID + "");
cashcreditInfo.SNumber = cashcreditInfo.SNumber + 1;
if (cashcreditInfo.SValues == 0)
{
cashcreditInfo.SValues = 0;
}
cashcreditBLL.Update(cashcreditInfo);
}
else
{
cashcreditInfo.UserID = getLoginID();
cashcreditInfo.BNumber = 0;
cashcreditInfo.BTradeNum = 0;
cashcreditInfo.BEndNum = 0;
cashcreditInfo.BValues = 5;
cashcreditInfo.SNumber = 1;
cashcreditInfo.STradeNum = 0;
cashcreditInfo.SEndNum = 0;
cashcreditInfo.SValues = 5;
cashcreditBLL.Add(cashcreditInfo);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.Cashcredit model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Cashcredit set ");
strSql.Append(" UserID = @UserID,");
strSql.Append(" BNumber = @BNumber,");
strSql.Append(" BTradeNum = @BTradeNum,");
strSql.Append(" BEndNum = @BEndNum,");
strSql.Append(" BValues = @BValues,");
strSql.Append(" SNumber = @SNumber,");
strSql.Append(" STradeNum = @STradeNum,");
strSql.Append(" SEndNum = @SEndNum,");
strSql.Append(" SValues = @SValues");
strSql.Append(" where CreditID=@CreditID ");
SqlParameter[] parameters =
{
new SqlParameter("@CreditID", SqlDbType.BigInt, 8),
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@BNumber", SqlDbType.Int, 4),
new SqlParameter("@BTradeNum", SqlDbType.Int, 4),
new SqlParameter("@BEndNum", SqlDbType.Int, 4),
new SqlParameter("@BValues", SqlDbType.Int, 4),
new SqlParameter("@SNumber", SqlDbType.Int, 4),
new SqlParameter("@STradeNum", SqlDbType.Int, 4),
new SqlParameter("@SEndNum", SqlDbType.Int, 4),
new SqlParameter("@SValues", SqlDbType.Int, 4)
};
parameters[0].Value = model.CreditID;
parameters[1].Value = model.UserID;
parameters[2].Value = model.BNumber;
parameters[3].Value = model.BTradeNum;
parameters[4].Value = model.BEndNum;
parameters[5].Value = model.BValues;
parameters[6].Value = model.SNumber;
parameters[7].Value = model.STradeNum;
parameters[8].Value = model.SEndNum;
parameters[9].Value = model.SValues;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public long Add(lgk.Model.Cashcredit model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Cashcredit(");
strSql.Append("SValues,UserID,BNumber,BTradeNum,BEndNum,BValues,SNumber,STradeNum,SEndNum");
strSql.Append(") values (");
strSql.Append("@SValues,@UserID,@BNumber,@BTradeNum,@BEndNum,@BValues,@SNumber,@STradeNum,@SEndNum");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserID", SqlDbType.BigInt, 8),
new SqlParameter("@BNumber", SqlDbType.Int, 4),
new SqlParameter("@BTradeNum", SqlDbType.Int, 4),
new SqlParameter("@BEndNum", SqlDbType.Int, 4),
new SqlParameter("@BValues", SqlDbType.Int, 4),
new SqlParameter("@SNumber", SqlDbType.Int, 4),
new SqlParameter("@STradeNum", SqlDbType.Int, 4),
new SqlParameter("@SEndNum", SqlDbType.Int, 4),
new SqlParameter("@SValues", SqlDbType.Int, 4)
};
parameters[0].Value = model.UserID;
parameters[1].Value = model.BNumber;
parameters[2].Value = model.BTradeNum;
parameters[3].Value = model.BEndNum;
parameters[4].Value = model.BValues;
parameters[5].Value = model.SNumber;
parameters[6].Value = model.STradeNum;
parameters[7].Value = model.SEndNum;
parameters[8].Value = model.SValues;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt64(obj));
}
}
/// <summary>
/// 显示数据
/// </summary>
private void ShowData()
{
lgk.Model.tb_Purchase purchaseInfo = purchaseBLL.GetModel(iPurchaseID);
if (purchaseInfo != null)
{
#region 用户信息
lgk.Model.tb_user userInfo = userBLL.GetModel(purchaseInfo.UserID);
ltUserCode.Text = userInfo.UserCode; //会员编号
ltBankName.Text = userInfo.BankName; //开户银行
ltTrueName.Text = userInfo.TrueName; //银行姓名
ltBankAccount.Text = userInfo.BankAccount; //银行帐号
ltBankAccountUser.Text = userInfo.BankAccountUser; //银行姓名
ltBankBranch.Text = userInfo.BankBranch; //开户网点
ltQQnumer.Text = userInfo.QQnumer; //卖家QQ号码
ltPhoneNum.Text = userInfo.PhoneNum; //卖家手机号码
#endregion
#region 求购信息
ltTitle.Text = purchaseInfo.Title;
ltNumber.Text = purchaseInfo.Number.ToString();
ltQuantity.Text = purchaseInfo.Quantity.ToString();
ltPrice.Text = purchaseInfo.Price.ToString("0.00");
ltFactorage.Text = purchaseInfo.Charge.ToString("0.00");
#endregion
#region 信用等级
lgk.Model.Cashcredit cashcreditInfo = cashcreditBLL.GetModel("UserID=" + purchaseInfo.UserID + "");
if (cashcreditInfo != null)
{
ltGrade.Text = cashcreditInfo.SValues.ToString();
}
#endregion
}
}
/// <summary>
/// 显示数据
/// </summary>
private void ShowData()
{
lgk.Model.Cashsell cashsellInfo = cashsellBLL.GetModel(iCashsellID);
if (cashsellInfo != null)
{
#region 商品信息
ltTitle.Text = cashsellInfo.Title;
ltAmount.Text = cashsellInfo.Amount.ToString("0.00");
ltNumber.Text = cashsellInfo.Number.ToString();
ltPrice.Text = cashsellInfo.Price.ToString("0.00");
ltUnitNum.Text = cashsellInfo.UnitNum.ToString();
#endregion
#region 卖家信息
lgk.Model.tb_user userInfo = userBLL.GetModel(cashsellInfo.UserID);
ltUserCode.Text = userInfo.UserCode; //会员编号
ltBankName.Text = userInfo.BankName; //开户银行
ltTrueName.Text = userInfo.TrueName; //银行姓名
ltBankAccount.Text = userInfo.BankAccount; //银行帐号
ltBankAccountUser.Text = userInfo.BankAccountUser; //银行姓名
ltBankBranch.Text = userInfo.BankBranch; //开户网点
ltQQnumer.Text = userInfo.QQnumer; //卖家QQ号码
ltPhoneNum.Text = userInfo.PhoneNum; //卖家手机号码
#endregion
#region 信用等级
lgk.Model.Cashcredit cashcreditInfo = cashcreditBLL.GetModel("UserID=" + cashsellInfo.UserID + "");
if (cashcreditInfo != null)
{
ltGrade.Text = cashcreditInfo.BValues.ToString();
}
#endregion
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.Cashcredit GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CreditID, UserID, BNumber, BTradeNum, BEndNum, BValues, SNumber, STradeNum, SEndNum, SValues");
strSql.Append(" from Cashcredit ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
lgk.Model.Cashcredit model = new lgk.Model.Cashcredit();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["CreditID"].ToString() != "")
{
model.CreditID = long.Parse(ds.Tables[0].Rows[0]["CreditID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["BNumber"].ToString() != "")
{
model.BNumber = int.Parse(ds.Tables[0].Rows[0]["BNumber"].ToString());
}
if (ds.Tables[0].Rows[0]["BTradeNum"].ToString() != "")
{
model.BTradeNum = int.Parse(ds.Tables[0].Rows[0]["BTradeNum"].ToString());
}
if (ds.Tables[0].Rows[0]["BEndNum"].ToString() != "")
{
model.BEndNum = int.Parse(ds.Tables[0].Rows[0]["BEndNum"].ToString());
}
if (ds.Tables[0].Rows[0]["BValues"].ToString() != "")
{
model.BValues = int.Parse(ds.Tables[0].Rows[0]["BValues"].ToString());
}
if (ds.Tables[0].Rows[0]["SNumber"].ToString() != "")
{
model.SNumber = int.Parse(ds.Tables[0].Rows[0]["SNumber"].ToString());
}
if (ds.Tables[0].Rows[0]["STradeNum"].ToString() != "")
{
model.STradeNum = int.Parse(ds.Tables[0].Rows[0]["STradeNum"].ToString());
}
if (ds.Tables[0].Rows[0]["SEndNum"].ToString() != "")
{
model.SEndNum = int.Parse(ds.Tables[0].Rows[0]["SEndNum"].ToString());
}
if (ds.Tables[0].Rows[0]["SValues"].ToString() != "")
{
model.SValues = int.Parse(ds.Tables[0].Rows[0]["SValues"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.Cashcredit GetModel(long CreditID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select CreditID, UserID, BNumber, BTradeNum, BEndNum, BValues, SNumber, STradeNum, SEndNum, SValues");
strSql.Append(" from Cashcredit ");
strSql.Append(" where CreditID=@CreditID");
SqlParameter[] parameters =
{
new SqlParameter("@CreditID", SqlDbType.BigInt, 8)
};
parameters[0].Value = CreditID;
lgk.Model.Cashcredit model = new lgk.Model.Cashcredit();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["CreditID"].ToString() != "")
{
model.CreditID = long.Parse(ds.Tables[0].Rows[0]["CreditID"].ToString());
}
if (ds.Tables[0].Rows[0]["UserID"].ToString() != "")
{
model.UserID = long.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
if (ds.Tables[0].Rows[0]["BNumber"].ToString() != "")
{
model.BNumber = int.Parse(ds.Tables[0].Rows[0]["BNumber"].ToString());
}
if (ds.Tables[0].Rows[0]["BTradeNum"].ToString() != "")
{
model.BTradeNum = int.Parse(ds.Tables[0].Rows[0]["BTradeNum"].ToString());
}
if (ds.Tables[0].Rows[0]["BEndNum"].ToString() != "")
{
model.BEndNum = int.Parse(ds.Tables[0].Rows[0]["BEndNum"].ToString());
}
if (ds.Tables[0].Rows[0]["BValues"].ToString() != "")
{
model.BValues = int.Parse(ds.Tables[0].Rows[0]["BValues"].ToString());
}
if (ds.Tables[0].Rows[0]["SNumber"].ToString() != "")
{
model.SNumber = int.Parse(ds.Tables[0].Rows[0]["SNumber"].ToString());
}
if (ds.Tables[0].Rows[0]["STradeNum"].ToString() != "")
{
model.STradeNum = int.Parse(ds.Tables[0].Rows[0]["STradeNum"].ToString());
}
if (ds.Tables[0].Rows[0]["SEndNum"].ToString() != "")
{
model.SEndNum = int.Parse(ds.Tables[0].Rows[0]["SEndNum"].ToString());
}
if (ds.Tables[0].Rows[0]["SValues"].ToString() != "")
{
model.SValues = int.Parse(ds.Tables[0].Rows[0]["SValues"].ToString());
}
return(model);
}
else
{
return(null);
}
}
