private Entities.CRMCustForNextVisit LoadSingleCRMCustForNextVisit(DataRow row) { Entities.CRMCustForNextVisit model = new Entities.CRMCustForNextVisit(); model.CrmCustID = row["CrmCustID"].ToString(); model.UserID = int.Parse(row["UserID"].ToString()); model.NextVisitDate = row["NextVisitDate"].ToString(); if (row["LastUpdateTime"].ToString() != "") { model.LastUpdateTime = DateTime.Parse(row["LastUpdateTime"].ToString()); } if (row["LastUpdateUserID"].ToString() != "") { model.LastUpdateUserID = int.Parse(row["LastUpdateUserID"].ToString()); } if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(row["CreateUserID"].ToString()); } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.CRMCustForNextVisit model) { SqlParameter[] parameters = { new SqlParameter("@CrmCustID", SqlDbType.VarChar, 50), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@NextVisitDate", SqlDbType.VarChar, 10), new SqlParameter("@LastUpdateTime", SqlDbType.DateTime), new SqlParameter("@LastUpdateUserID", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Value = model.CrmCustID; parameters[1].Value = model.UserID; parameters[2].Value = model.NextVisitDate; parameters[3].Value = model.LastUpdateTime; parameters[4].Value = model.LastUpdateUserID; parameters[5].Value = model.CreateTime; parameters[6].Value = model.CreateUserID; return(SqlHelper.ExecuteNonQuery(sqltran, CommandType.StoredProcedure, P_CRMCUSTFORNEXTVISIT_UPDATE, parameters)); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.CRMCustForNextVisit model) { SqlParameter[] parameters = { new SqlParameter("@CrmCustID", SqlDbType.VarChar, 50), new SqlParameter("@UserID", SqlDbType.Int), new SqlParameter("@NextVisitDate", SqlDbType.VarChar, 10), new SqlParameter("@LastUpdateTime", SqlDbType.DateTime), new SqlParameter("@LastUpdateUserID", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Value = model.CrmCustID; parameters[1].Value = model.UserID; parameters[2].Value = model.NextVisitDate; parameters[3].Value = model.LastUpdateTime; parameters[4].Value = model.LastUpdateUserID; parameters[5].Value = model.CreateTime; parameters[6].Value = model.CreateUserID; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_CRMCUSTFORNEXTVISIT_INSERT, parameters); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(SqlTransaction sqltran, Entities.CRMCustForNextVisit model) { Dal.CRMCustForNextVisit.Instance.Insert(sqltran, model); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.CRMCustForNextVisit model) { Dal.CRMCustForNextVisit.Instance.Insert(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(SqlTransaction sqltran, Entities.CRMCustForNextVisit model) { return(Dal.CRMCustForNextVisit.Instance.Update(sqltran, model)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.CRMCustForNextVisit model) { return(Dal.CRMCustForNextVisit.Instance.Update(model)); }