/// <summary>
/// 新增物流跟进
/// </summary>
/// <param name="buyprocess"></param>
/// <returns></returns>
public int InsBuyFollow(BuyProcess buyprocess)
{
string sql = @"INSERT INTO T_BuyProcess
(BP_Code
,BP_Datetime
,BP_Opt
,BP_Ope
,BP_Remark)
Values
(@BP_Code
,@BP_Datetime
,@BP_Opt
,@BP_Ope
,@BP_Remark)";
SqlParameter[] sps =
{
new SqlParameter("@BP_Code", XYEEncoding.strCodeHex(buyprocess.BP_Code)),
new SqlParameter("@BP_Datetime", buyprocess.BP_Datetime),
new SqlParameter("@BP_Opt", XYEEncoding.strCodeHex(buyprocess.BP_Opt)),
new SqlParameter("@BP_Ope", XYEEncoding.strCodeHex(buyprocess.BP_Ope)),
new SqlParameter("@BP_Remark", XYEEncoding.strCodeHex(buyprocess.BP_Remark))
};
return(DbHelperSQL.ExecuteSql(sql, sps));
}
private int InsBuyProcessFun()
{
BuyProcess bp = new BuyProcess();
bp.BP_Code = txt_buycode.Text.Trim();
bp.BP_Datetime = Convert.ToDateTime(dateTimeInput1.Text);
bp.BP_Opt = cbo_caozuo.Text.Trim();
bp.BP_Ope = txt_caozuoman.Text.Trim();
bp.BP_Remark = txt_beizhu.Text.Trim();
return(bpm.InsBuyFollow(bp));
}
public void BuyTestFullProcess()
{
//arrange
MBuySell buy = new MBuySell(); buy.id = "666";
MQReq query = new MQReq();
MQCommodity market = new MQCommodity(); market.ask = "1";
MarketException excp = new MarketException();
CommStubStaticReturn comm = new CommStubStaticReturn(buy,
null, null, excp, market, null, null, null);
BuyProcess testProcess = new BuyProcess(true, comm, 1, 1, 1, 1);
//initial assert
Assert.AreEqual(testProcess.currIndex, 0);
Assert.AreEqual(testProcess.queue, LogicQueue.first);
//act1
object output = testProcess.run();
//assert1
Assert.AreEqual(testProcess.currIndex, 1);
Assert.AreEqual(testProcess.queue, LogicQueue.first);
//act2
output = testProcess.run();
//assert2
Assert.AreEqual(testProcess.currIndex, 2);
Assert.AreEqual(testProcess.queue, LogicQueue.first);
//update communicator stub
comm = new CommStubStaticReturn(buy,
null, null, query, market, null, null, null);
testProcess.comm = comm;
//act3
output = testProcess.run();
//assert3
Assert.AreEqual(testProcess.currIndex, 0);
Assert.AreEqual(testProcess.queue, LogicQueue.last);
//act4
output = testProcess.run();
//assert4
Assert.AreEqual(testProcess.currIndex, 0);
Assert.AreEqual(testProcess.queue, LogicQueue.last);
}
public void BuyTestHasExisitingRequest()
{
//arrange
MQReq query = new MQReq();
CommStubStaticReturn comm = new CommStubStaticReturn(null,
null, null, query, null, null, null, null);
BuyProcess testProcess = new BuyProcess(false, comm, 1, 1, 1, 1);
//initial assert
Assert.AreEqual(testProcess.currIndex, 0);
Assert.AreEqual(testProcess.repeat, false);
Assert.AreEqual(testProcess.queue, LogicQueue.first);
//act
object output = testProcess.run();
//assert
Assert.AreEqual(testProcess.repeat, false);
Assert.AreEqual(testProcess.queue, LogicQueue.last);
Assert.IsInstanceOfType(output, typeof(LogicProcess));
Assert.AreEqual(testProcess.currIndex, 0);
}
/// <summary>
/// 根据code更新数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateByCode(BuyProcess model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_BuyProcess set ");
strSql.Append("BP_SellLineno=@BP_SellLineno,");
strSql.Append("BP_Datetime=@BP_Datetime,");
strSql.Append("BP_Opt=@BP_Opt,");
strSql.Append("BP_Remark=@BP_Remark,");
strSql.Append("BP_Clear=@BP_Clear");
strSql.Append(" where BP_Code=@BP_Code");
SqlParameter[] parameters =
{
new SqlParameter("@BP_SellLineno", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_Datetime", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_Opt", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_Clear", SqlDbType.Int, 4),
new SqlParameter("@BP_Code", SqlDbType.NVarChar, 512)
};
parameters[0].Value = model.BP_SellLineno;
parameters[1].Value = model.BP_Datetime;
parameters[2].Value = model.BP_Opt;
parameters[3].Value = model.BP_Remark;
parameters[4].Value = model.BP_Clear;
parameters[4].Value = model.BP_Code;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BuyProcess model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_BuyProcess(");
strSql.Append("BP_Code,BP_SellLineno,BP_Datetime,BP_Opt,BP_Ope,BP_Remark,BP_Clear)");
strSql.Append(" values (");
strSql.Append("@BP_Code,@BP_SellLineno,@BP_Datetime,@BP_Opt,@BP_Ope,@BP_Remark,@BP_Clear)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@BP_Code", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_SellLineno", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_Datetime", SqlDbType.DateTime),
new SqlParameter("@BP_Opt", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_Ope", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_Remark", SqlDbType.NVarChar, 512),
new SqlParameter("@BP_Clear", SqlDbType.Int, 4)
};
parameters[0].Value = model.BP_Code;
parameters[1].Value = model.BP_SellLineno;
parameters[2].Value = model.BP_Datetime;
parameters[3].Value = model.BP_Opt;
parameters[4].Value = model.BP_Ope;
parameters[5].Value = model.BP_Remark;
parameters[6].Value = model.BP_Clear;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 新增物流跟进
/// </summary>
/// <param name="buyprocess"></param>
/// <returns></returns>
public int InsBuyFollow(BuyProcess buyprocess)
{
return(dal.InsBuyFollow(buyprocess));
}
