/// <summary>
/// 改变订单的所有产品的设计状态
/// </summary>
/// <param name="orderNo">订单号</param>
/// <param name="orderIndices">订单产品索引集</param>
/// <param name="state">要更改为的目标状态</param>
/// <returns>是否执行成功</returns>
public bool ChangeDesignState(string orderNo, Model.DesignState state)
{
if (string.IsNullOrWhiteSpace(orderNo))
{
return(false);
}
string strSql = string.Format(@"UPDATE OrderDesign SET [State] ={0} WHERE OrderNO = '{1}'", (byte)state, orderNo);
return(ExecuteNonQuery(strSql) > 0);
}
/// <summary>
/// 改变订单指定产品索引的产品的设计状态
/// </summary>
/// <param name="orderNo"></param>
/// <param name="orderindices"></param>
/// <param name="state"></param>
/// <returns></returns>
public bool ChangeDesignState(string orderNo, string[] orderindices, Model.DesignState state)
{
string sqlString = string.Format("update OrderDesign set [State]={0} where OrderNO='{1}' and OrderIndex in ('{2}')", (byte)state, orderNo, string.Join("','", orderindices));
return(ExecuteNonQuery(sqlString) > 0);
}
