/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.WorkOrderReceiver model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@OrderID", SqlDbType.NVarChar, 20), new SqlParameter("@RevertContent", SqlDbType.NVarChar, 1000), new SqlParameter("@ReceiverUserID", SqlDbType.Int, 4), new SqlParameter("@ReceiverDepartName", SqlDbType.NVarChar, 50), new SqlParameter("@CallID", SqlDbType.BigInt, 8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Direction = ParameterDirection.Output; parameters[1].Value = model.OrderID; parameters[2].Value = model.RevertContent; parameters[3].Value = model.ReceiverUserID; parameters[4].Value = model.ReceiverDepartName; parameters[5].Value = model.CallID; parameters[6].Value = model.CreateTime; parameters[7].Value = model.CreateUserID; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_WorkOrderReceiver_INSERT, parameters); return((int)parameters[0].Value); }
/// <summary> /// 增加一条数据 /// </summary> public long Insert(Entities.WorkOrderRevert model) { int intVal = 0; Entities.WorkOrderReceiver receiver = new Entities.WorkOrderReceiver(); Entities.WorkOrderLog log = new Entities.WorkOrderLog(); receiver.OrderID = model.OrderID; receiver.CallID = model.CallID; receiver.CreateTime = DateTime.Now; receiver.CreateUserID = model.CreateUserID; receiver.ReceiverDepartName = model.ReceiverDepartName; receiver.RevertContent = model.RevertContent; if (int.TryParse(model.ReceiverID, out intVal)) { receiver.ReceiverUserID = intVal; } log.CreateTime = model.CreateTime; log.CreateUserID = model.CreateUserID; log.OrderID = model.OrderID; log.LogDesc = GetLogDescByModel(model); int recid = BLL.WorkOrderReceiver.Instance.Insert(receiver); log.ReceiverRecID = recid; BLL.WorkOrderLog.Instance.Insert(log); return(recid); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.WorkOrderRevert model) { int ReturnID = 0; int intVal = 0; Entities.WorkOrderReceiver receiver = new Entities.WorkOrderReceiver(); Entities.WorkOrderLog log = new Entities.WorkOrderLog(); receiver = BLL.WorkOrderReceiver.Instance.GetWorkOrderReceiver((int)model.WORID); log = BLL.WorkOrderLog.Instance.GetWorkOrderLogByReceiverRecID((int)model.WORID); if (receiver != null && log != null) { receiver.CallID = model.CallID; receiver.ReceiverDepartName = model.ReceiverDepartName; receiver.RevertContent = model.RevertContent; if (int.TryParse(model.ReceiverID, out intVal)) { receiver.ReceiverUserID = intVal; } log.LogDesc = GetLogDescByModel(model); ReturnID = BLL.WorkOrderReceiver.Instance.Update(receiver); BLL.WorkOrderLog.Instance.Update(log); } return(ReturnID); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.WorkOrderReceiver model) { SqlParameter[] parameters = { new SqlParameter("@RecID", SqlDbType.Int, 4), new SqlParameter("@OrderID", SqlDbType.NVarChar, 20), new SqlParameter("@RevertContent", SqlDbType.NVarChar, 1000), new SqlParameter("@ReceiverUserID", SqlDbType.Int, 4), new SqlParameter("@ReceiverDepartName", SqlDbType.NVarChar, 50), new SqlParameter("@CallID", SqlDbType.BigInt, 8), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Value = model.RecID; parameters[1].Value = model.OrderID; parameters[2].Value = model.RevertContent; parameters[3].Value = model.ReceiverUserID; parameters[4].Value = model.ReceiverDepartName; parameters[5].Value = model.CallID; parameters[6].Value = model.CreateTime; parameters[7].Value = model.CreateUserID; return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_WorkOrderReceiver_UPDATE, parameters)); }
/// <summary> /// 得到一个对象实体 /// </summary> public Entities.WorkOrderRevert GetWorkOrderRevert(long WORID) { Entities.WorkOrderReceiver receiver = BLL.WorkOrderReceiver.Instance.GetWorkOrderReceiver((int)WORID); Entities.WorkOrderLog log = BLL.WorkOrderLog.Instance.GetWorkOrderLogByReceiverRecID((int)WORID); Entities.WorkOrderRevert model = new Entities.WorkOrderRevert(); if (receiver != null && log != null) { model = GetWorkOrderRevertByLogDesc(log.LogDesc); model.CallID = receiver.CallID; model.CreateTime = receiver.CreateTime; model.CreateUserID = receiver.CreateUserID; model.OrderID = receiver.OrderID; model.ReceiverDepartName = receiver.ReceiverDepartName; model.ReceiverID = receiver.ReceiverUserID.ToString(); model.WORID = receiver.RecID; model.AudioURL = receiver.AudioURL; return(model); } else { return(null); } }
private Entities.WorkOrderReceiver LoadSingleWorkOrderReceiver(DataRow row) { Entities.WorkOrderReceiver model = new Entities.WorkOrderReceiver(); if (row["RecID"].ToString() != "") { model.RecID = int.Parse(row["RecID"].ToString()); } model.OrderID = row["OrderID"].ToString(); model.RevertContent = row["RevertContent"].ToString(); if (row["ReceiverUserID"].ToString() != "") { model.ReceiverUserID = int.Parse(row["ReceiverUserID"].ToString()); } model.ReceiverDepartName = row["ReceiverDepartName"].ToString(); if (row["CallID"].ToString() != "") { model.CallID = long.Parse(row["CallID"].ToString()); } if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(row["CreateUserID"].ToString()); } if (row["AudioURL"].ToString() != "") { model.AudioURL = row["AudioURL"].ToString(); } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(SqlTransaction sqltran, Entities.WorkOrderReceiver model) { return(Dal.WorkOrderReceiver.Instance.Insert(sqltran, model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.WorkOrderReceiver model) { return(Dal.WorkOrderReceiver.Instance.Insert(model)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.WorkOrderReceiver model) { return(Dal.WorkOrderReceiver.Instance.Update(model)); }