/// <summary> /// 增加一条数据 /// </summary> public void Insert(SqlTransaction sqltran, Entities.AutoCall_ProjectInfo model) { SqlParameter[] parameters = { new SqlParameter("@ProjectID", SqlDbType.BigInt, 8), new SqlParameter("@SkillID", SqlDbType.Int, 4), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@ACStatus", SqlDbType.Int, 4), new SqlParameter("@CallNum", SqlDbType.VarChar, 50), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4), new SqlParameter("@ModifyTime", SqlDbType.DateTime), new SqlParameter("@ModifyUserID", SqlDbType.Int, 4), new SqlParameter("@TotalTaskNum", SqlDbType.Int, 4), new SqlParameter("@AppendDataTime", SqlDbType.DateTime) }; //new SqlParameter("@Timestamp", SqlDbType.Timestamp,8)}; parameters[0].Value = model.ProjectID; parameters[1].Value = model.SkillID; parameters[2].Value = model.Status; parameters[3].Value = model.ACStatus; parameters[4].Value = model.CallNum; parameters[5].Value = model.CreateTime; parameters[6].Value = model.CreateUserID; parameters[7].Value = model.ModifyTime; parameters[8].Value = model.ModifyUserID; parameters[9].Value = model.TotalTaskNum; parameters[10].Value = model.AppendDataTime; //parameters[11].Value = model.Timestamp; SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_AUTOCALL_PROJECTINFO_INSERT, parameters); }
private Entities.AutoCall_ProjectInfo LoadSingleAutoCall_ProjectInfo(DataRow row) { Entities.AutoCall_ProjectInfo model = new Entities.AutoCall_ProjectInfo(); if (row["ProjectID"].ToString() != "") { model.ProjectID = long.Parse(row["ProjectID"].ToString()); } if (row["SkillID"].ToString() != "") { model.SkillID = int.Parse(row["SkillID"].ToString()); } if (row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } if (row["ACStatus"].ToString() != "") { model.ACStatus = int.Parse(row["ACStatus"].ToString()); } model.CallNum = row["CallNum"].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["ModifyTime"].ToString() != "") { model.ModifyTime = DateTime.Parse(row["ModifyTime"].ToString()); } if (row["ModifyUserID"].ToString() != "") { model.ModifyUserID = int.Parse(row["ModifyUserID"].ToString()); } if (row["TotalTaskNum"].ToString() != "") { model.TotalTaskNum = int.Parse(row["TotalTaskNum"].ToString()); } if (row["AppendDataTime"].ToString() != "") { model.AppendDataTime = DateTime.Parse(row["AppendDataTime"].ToString()); } //model.Timestamp=row["Timestamp"].ToString(); return(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.AutoCall_ProjectInfo model) { return(Dal.AutoCall_ProjectInfo.Instance.Update(sqltran, model)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.AutoCall_ProjectInfo model) { return(Dal.AutoCall_ProjectInfo.Instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(SqlTransaction sqltran, Entities.AutoCall_ProjectInfo model) { Dal.AutoCall_ProjectInfo.Instance.Insert(sqltran, model); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.AutoCall_ProjectInfo model) { Dal.AutoCall_ProjectInfo.Instance.Insert(model); }