/// <summary>
/// 更新出入库订单返回金蝶状态
/// </summary>
public static bool UpdateBatchPlanReturnState(string batchPlanId)
{
DataManager dm = new Invengo.RiceManangeServices.DBCommon.DataManager();
DBCommand cmd = dm.CreateDBCommand(CommandType.Text);
cmd.ClearParameters();
cmd.setCommandText("update batchplan set upload=0 where batchplanid=@batchPlanId");
cmd.AddParameter("@batchPlanId", batchPlanId);
return(dm.ExecNonQueryCommand(cmd));
}
/// <summary>
/// 执行某条语句
/// </summary>
/// <returns></returns>
public static bool ExecNonQuerySql(string sql, List <SqlParameter> listSqlPara)
{
DataManager dm = new Invengo.RiceManangeServices.DBCommon.DataManager();
DBCommand cmd = dm.CreateDBCommand(CommandType.Text);
cmd.setCommandText(sql);
if (listSqlPara != null && listSqlPara.Count > 0)
{
for (int i = 0; i < listSqlPara.Count; i++)
{
cmd.AddParameter(listSqlPara[i]);
}
}
return(dm.ExecNonQueryCommand(cmd));
}
