/// <summary> /// 得到一个对象实体 /// </summary> public tabExperienceProjectModel GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" from tabExperienceProject "); strSql.Append(" where id=SQL2012id"); SqlParameter[] parameters = { new SqlParameter("SQL2012id", SqlDbType.Int, 4) }; parameters[0].Value = id; tabExperienceProjectModel model = new tabExperienceProjectModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(ModelHandler <tabExperienceProjectModel> .FillModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tabExperienceProjectModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(tabExperienceProjectModel model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(tabExperienceProjectModel model, List <string> ChangedFields) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tabExperienceProject set "); strSql.Append(" OrgID = SQL2012OrgID , "); strSql.Append(" ProjectName = SQL2012ProjectName , "); strSql.Append(" ProjectBeginDate = SQL2012ProjectBeginDate , "); strSql.Append(" ProjectEndDate = SQL2012ProjectEndDate , "); strSql.Append(" ProjectDesc = SQL2012ProjectDesc , "); strSql.Append(" ProjectPosition = SQL2012ProjectPosition , "); strSql.Append(" ProjectPerformance = SQL2012ProjectPerformance , "); strSql.Append(" AppID = SQL2012AppID , "); strSql.Append(" Version = SQL2012Version , "); strSql.Append(" RandomNo = SQL2012RandomNo , "); strSql.Append(" ParentID = SQL2012ParentID , "); strSql.Append(" Remark = SQL2012Remark , "); strSql.Append(" LableText = SQL2012LableText , "); strSql.Append(" ExJson = SQL2012ExJson , "); strSql.Append(" Status = SQL2012Status , "); strSql.Append(" OrderNo = SQL2012OrderNo , "); strSql.Append(" CreateDate = SQL2012CreateDate , "); strSql.Append(" ModifyDate = SQL2012ModifyDate , "); strSql.Append(" CreateUser = SQL2012CreateUser , "); strSql.Append(" ModifyUser = SQL2012ModifyUser "); strSql.Append(" where id=SQL2012id "); SqlParameter[] parameters = { new SqlParameter("SQL2012OrgID", SqlDbType.Int, 4), new SqlParameter("SQL2012ProjectName", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012ProjectBeginDate", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012ProjectEndDate", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012ProjectDesc", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012ProjectPosition", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012ProjectPerformance", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012id", SqlDbType.Int, 4), new SqlParameter("SQL2012AppID", SqlDbType.NVarChar, 100), new SqlParameter("SQL2012Version", SqlDbType.NVarChar, 100), new SqlParameter("SQL2012RandomNo", SqlDbType.NVarChar, 200), new SqlParameter("SQL2012ParentID", SqlDbType.Int, 4), new SqlParameter("SQL2012Remark", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012LableText", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012ExJson", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012Status", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012OrderNo", SqlDbType.Int, 4), new SqlParameter("SQL2012CreateDate", SqlDbType.NVarChar, 200), new SqlParameter("SQL2012ModifyDate", SqlDbType.NVarChar, 200), new SqlParameter("SQL2012CreateUser", SqlDbType.Int, 4), new SqlParameter("SQL2012ModifyUser", SqlDbType.Int, 4) }; parameters[0].Value = model.OrgID; parameters[1].Value = model.ProjectName; parameters[2].Value = model.ProjectBeginDate; parameters[3].Value = model.ProjectEndDate; parameters[4].Value = model.ProjectDesc; parameters[5].Value = model.ProjectPosition; parameters[6].Value = model.ProjectPerformance; parameters[7].Value = model.id; parameters[8].Value = model.AppID; parameters[9].Value = model.Version; parameters[10].Value = model.RandomNo; parameters[11].Value = model.ParentID; parameters[12].Value = model.Remark; parameters[13].Value = model.LableText; parameters[14].Value = model.ExJson; parameters[15].Value = model.Status; parameters[16].Value = model.OrderNo; parameters[17].Value = model.CreateDate; parameters[18].Value = model.ModifyDate; parameters[19].Value = model.CreateUser; parameters[20].Value = model.ModifyUser; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(tabExperienceProjectModel model) { model.Version = model.Version.IsNotNullOrEmpty()? model.Version: "1"; model.RandomNo = model.RandomNo.IsNotNullOrEmpty()? model.RandomNo: Guid.NewGuid().ToString("N"); model.Status = model.Status.IsNotNullOrEmpty()? model.Status: "1"; model.OrderNo = model.OrderNo > 0? model.OrderNo: 1; model.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); model.ModifyDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tabExperienceProject("); strSql.Append("OrgID,ProjectName,ProjectBeginDate,ProjectEndDate,ProjectDesc,ProjectPosition,ProjectPerformance,AppID,Version,RandomNo,ParentID,Remark,LableText,ExJson,Status,OrderNo,CreateDate,ModifyDate,CreateUser,ModifyUser"); strSql.Append(") values ("); strSql.Append("SQL2012OrgID,SQL2012ProjectName,SQL2012ProjectBeginDate,SQL2012ProjectEndDate,SQL2012ProjectDesc,SQL2012ProjectPosition,SQL2012ProjectPerformance,SQL2012AppID,SQL2012Version,SQL2012RandomNo,SQL2012ParentID,SQL2012Remark,SQL2012LableText,SQL2012ExJson,SQL2012Status,SQL2012OrderNo,SQL2012CreateDate,SQL2012ModifyDate,SQL2012CreateUser,SQL2012ModifyUser"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("SQL2012OrgID", SqlDbType.Int, 4), new SqlParameter("SQL2012ProjectName", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012ProjectBeginDate", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012ProjectEndDate", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012ProjectDesc", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012ProjectPosition", SqlDbType.NVarChar, 50), new SqlParameter("SQL2012ProjectPerformance", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012AppID", SqlDbType.NVarChar, 100), new SqlParameter("SQL2012Version", SqlDbType.NVarChar, 100), new SqlParameter("SQL2012RandomNo", SqlDbType.NVarChar, 200), new SqlParameter("SQL2012ParentID", SqlDbType.Int, 4), new SqlParameter("SQL2012Remark", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012LableText", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012ExJson", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012Status", SqlDbType.NVarChar, -1), new SqlParameter("SQL2012OrderNo", SqlDbType.Int, 4), new SqlParameter("SQL2012CreateDate", SqlDbType.NVarChar, 200), new SqlParameter("SQL2012ModifyDate", SqlDbType.NVarChar, 200), new SqlParameter("SQL2012CreateUser", SqlDbType.Int, 4), new SqlParameter("SQL2012ModifyUser", SqlDbType.Int, 4) }; parameters[0].Value = model.OrgID; parameters[1].Value = model.ProjectName; parameters[2].Value = model.ProjectBeginDate; parameters[3].Value = model.ProjectEndDate; parameters[4].Value = model.ProjectDesc; parameters[5].Value = model.ProjectPosition; parameters[6].Value = model.ProjectPerformance; parameters[7].Value = model.AppID; parameters[8].Value = model.Version; parameters[9].Value = model.RandomNo; parameters[10].Value = model.ParentID; parameters[11].Value = model.Remark; parameters[12].Value = model.LableText; parameters[13].Value = model.ExJson; parameters[14].Value = model.Status; parameters[15].Value = model.OrderNo; parameters[16].Value = model.CreateDate; parameters[17].Value = model.ModifyDate; parameters[18].Value = model.CreateUser; parameters[19].Value = model.ModifyUser; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }