/// <summary> /// 新增药师回拨 /// </summary> /// <param name="info"></param> /// <returns></returns> public int AddProductOutBook(ProductOutBookInfo info) { string sqlCommand = "ProductOutBook_Insert"; DbCommand dbCommand = dbw.GetStoredProcCommand(sqlCommand); dbw.AddOutParameter(dbCommand, "OutID", DbType.Int32, 4); dbw.AddInParameter(dbCommand, "ProductID", DbType.Int32, info.ProductID); dbw.AddInParameter(dbCommand, "ProductName", DbType.String, info.ProductName); dbw.AddInParameter(dbCommand, "ProductCode", DbType.String, info.ProductCode); dbw.AddInParameter(dbCommand, "TradePrice", DbType.Decimal, info.TradePrice); dbw.AddInParameter(dbCommand, "Name", DbType.String, info.Name); dbw.AddInParameter(dbCommand, "UID", DbType.Int32, info.UID); dbw.AddInParameter(dbCommand, "Mobile", DbType.String, info.Mobile); dbw.AddInParameter(dbCommand, "Message", DbType.String, info.Message); dbw.AddInParameter(dbCommand, "Quantity", DbType.Int32, info.Quantity); dbw.AddInParameter(dbCommand, "CreateTime", DbType.DateTime, info.CreateTime); dbw.AddInParameter(dbCommand, "UpdateTime", DbType.DateTime, info.UpdateTime); dbw.AddInParameter(dbCommand, "Status", DbType.Int16, info.Status); dbw.AddInParameter(dbCommand, "HasBuy", DbType.Int16, info.HasBuy); dbw.ExecuteNonQuery(dbCommand); return(int.Parse(dbw.GetParameterValue(dbCommand, "OutID").ToString())); }
/// <summary> /// 新增药师回拨 /// </summary> /// <param name="info"></param> /// <returns></returns> public int Add(ProductOutBookInfo info) { return(dal.AddProductOutBook(info)); }
/// <summary> /// ProductOutBook 数据获取 /// </summary> /// <param name="tbName"></param> static void SQLProductOutBook_Insert() { DateTime crrTime = DateTime.Now; sucessSum = 0; errorSum = 0; Console.WriteLine(string.Format("========================= BEGIN ProductOutBook")); try { // 查询待同步数据 DataTable dTable = OrdersBLL.Instance.GetList(0, beginTime.ToString(), 0, 0, "ProductOutBook"); if (dTable == null || dTable.Rows.Count <= 0) { ConsoleMsg("ProductOutBook 有0条数据等待同步"); } else { ConsoleMsg(string.Format("ProductOutBook 有{0}条数据等待同步", dTable.Rows.Count)); } // 同步数据 ProductOutBookInfo info = null; foreach (DataRow row in dTable.Rows) { // 转换数据 try { info = new ProductOutBookInfo() { Status = 0, HasBuy = 0 }; info.ProductID = int.Parse(row["ProductID"].ToString()); info.ProductName = row["ProductName"].ToString(); info.ProductCode = row["ProductCode"].ToString(); info.TradePrice = (string.IsNullOrEmpty(row["TradePrice"].ToString())) ? 0 : decimal.Parse(row["TradePrice"].ToString()); info.Name = row["UserName"].ToString(); info.UID = int.Parse(row["UID"].ToString()); info.Mobile = row["Mobile"].ToString(); info.Message = string.Format("{1} {0}", (row["Type"].ToString() == "1") ? "申请药师回拨" : "缺货登记", row["Message"].ToString()); info.Quantity = (string.IsNullOrEmpty(row["Quantity"].ToString())) ? 0 : int.Parse(row["Quantity"].ToString()); info.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); info.UpdateTime = crrTime; } catch (Exception ex) { errorSum++; ConsoleMsg(string.Format("ProductOutBook 数据:{0} Mobile:{1} 转换失败:{2}", row["ProductID"].ToString(), row["Mobile"].ToString(), ex.Message)); continue; } // 保存 try { int outId = ProductOutBookSqlBLL.Instance.Add(info); if (outId > 0) { sucessSum++; } else { errorSum++; ConsoleMsg(string.Format("ProductOutBook 数据:{0} Mobile:{1} 保存失败", info.ProductID, info.Mobile)); } } catch (Exception ex) { errorSum++; ConsoleMsg(string.Format("ProductOutBook 数据:{0} Mobile:{1} 保存失败:{2}", info.ProductID, info.Mobile, ex.Message)); } } ConsoleMsg(string.Format("ProductOutBook 同步完成:{0} 失败:{1}", sucessSum, errorSum)); } catch (Exception ex) { ConsoleMsg(string.Format("ProductOutBook ERROR:{0}", ex.Message)); } Console.WriteLine("========================= END ProductOutBook\r\n"); Console.WriteLine("\r\n"); }