/// <summary> /// 增加一条数据 /// </summary> public bool Add(AMS.Model.View_CallBackErrorInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into View_CallBackErrorInfo("); strSql.Append("SchoolNum,SchoolName,SchoolDTUip,SchoolDescribe,SchoolCon,SchoolLinkMan,SchoolLinkAddress,SchoolCardInfo,SchoolInterfaceInfo,FbPerson,FbTime,SolveTime,SolveWay,ProblemType,FbDescribe,ID,SolveLoginId,SolveUserPwd,SolveRemark,SolveUserName,SolveBranchName,MarkBrandName,MarkUserPwd,MarkLoginId,MarkRemark,MarkUserName)"); strSql.Append(" values ("); strSql.Append("@SchoolNum,@SchoolName,@SchoolDTUip,@SchoolDescribe,@SchoolCon,@SchoolLinkMan,@SchoolLinkAddress,@SchoolCardInfo,@SchoolInterfaceInfo,@FbPerson,@FbTime,@SolveTime,@SolveWay,@ProblemType,@FbDescribe,@ID,@SolveLoginId,@SolveUserPwd,@SolveRemark,@SolveUserName,@SolveBranchName,@MarkBrandName,@MarkUserPwd,@MarkLoginId,@MarkRemark,@MarkUserName)"); SqlParameter[] parameters = { new SqlParameter("@SchoolNum", SqlDbType.NVarChar, 50), new SqlParameter("@SchoolName", SqlDbType.NVarChar, 30), new SqlParameter("@SchoolDTUip", SqlDbType.NVarChar, 20), new SqlParameter("@SchoolDescribe", SqlDbType.NVarChar, 200), new SqlParameter("@SchoolCon", SqlDbType.NVarChar, 200), new SqlParameter("@SchoolLinkMan", SqlDbType.NVarChar, 300), new SqlParameter("@SchoolLinkAddress", SqlDbType.NVarChar, 300), new SqlParameter("@SchoolCardInfo", SqlDbType.Text), new SqlParameter("@SchoolInterfaceInfo", SqlDbType.Text), new SqlParameter("@FbPerson", SqlDbType.NVarChar, 20), new SqlParameter("@FbTime", SqlDbType.DateTime), new SqlParameter("@SolveTime", SqlDbType.DateTime), new SqlParameter("@SolveWay", SqlDbType.NVarChar, 500), new SqlParameter("@ProblemType", SqlDbType.Int, 4), new SqlParameter("@FbDescribe", SqlDbType.NVarChar, 500), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@SolveLoginId", SqlDbType.NVarChar, 30), new SqlParameter("@SolveUserPwd", SqlDbType.NVarChar, 30), new SqlParameter("@SolveRemark", SqlDbType.NVarChar, 50), new SqlParameter("@SolveUserName", SqlDbType.NVarChar, 30), new SqlParameter("@SolveBranchName", SqlDbType.NVarChar, 30), new SqlParameter("@MarkBrandName", SqlDbType.NVarChar, 30), new SqlParameter("@MarkUserPwd", SqlDbType.NVarChar, 30), new SqlParameter("@MarkLoginId", SqlDbType.NVarChar, 30), new SqlParameter("@MarkRemark", SqlDbType.NVarChar, 50), new SqlParameter("@MarkUserName", SqlDbType.NVarChar, 30) }; parameters[0].Value = model.SchoolNum; parameters[1].Value = model.SchoolName; parameters[2].Value = model.SchoolDTUip; parameters[3].Value = model.SchoolDescribe; parameters[4].Value = model.SchoolCon; parameters[5].Value = model.SchoolLinkMan; parameters[6].Value = model.SchoolLinkAddress; parameters[7].Value = model.SchoolCardInfo; parameters[8].Value = model.SchoolInterfaceInfo; parameters[9].Value = model.FbPerson; parameters[10].Value = model.FbTime; parameters[11].Value = model.SolveTime; parameters[12].Value = model.SolveWay; parameters[13].Value = model.ProblemType; parameters[14].Value = model.FbDescribe; parameters[15].Value = model.ID; parameters[16].Value = model.SolveLoginId; parameters[17].Value = model.SolveUserPwd; parameters[18].Value = model.SolveRemark; parameters[19].Value = model.SolveUserName; parameters[20].Value = model.SolveBranchName; parameters[21].Value = model.MarkBrandName; parameters[22].Value = model.MarkUserPwd; parameters[23].Value = model.MarkLoginId; parameters[24].Value = model.MarkRemark; parameters[25].Value = model.MarkUserName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AMS.Model.View_CallBackErrorInfo GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SchoolNum,SchoolName,SchoolDTUip,SchoolDescribe,SchoolCon,SchoolLinkMan,SchoolLinkAddress,SchoolCardInfo,SchoolInterfaceInfo,FbPerson,FbTime,SolveTime,SolveWay,ProblemType,FbDescribe,ID,SolveLoginId,SolveUserPwd,SolveRemark,SolveUserName,SolveBranchName,MarkBrandName,MarkUserPwd,MarkLoginId,MarkRemark,MarkUserName from View_CallBackErrorInfo "); strSql.Append(" where "); SqlParameter[] parameters = { }; AMS.Model.View_CallBackErrorInfo model = new AMS.Model.View_CallBackErrorInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SchoolNum"] != null && ds.Tables[0].Rows[0]["SchoolNum"].ToString() != "") { model.SchoolNum = ds.Tables[0].Rows[0]["SchoolNum"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolName"] != null && ds.Tables[0].Rows[0]["SchoolName"].ToString() != "") { model.SchoolName = ds.Tables[0].Rows[0]["SchoolName"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolDTUip"] != null && ds.Tables[0].Rows[0]["SchoolDTUip"].ToString() != "") { model.SchoolDTUip = ds.Tables[0].Rows[0]["SchoolDTUip"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolDescribe"] != null && ds.Tables[0].Rows[0]["SchoolDescribe"].ToString() != "") { model.SchoolDescribe = ds.Tables[0].Rows[0]["SchoolDescribe"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolCon"] != null && ds.Tables[0].Rows[0]["SchoolCon"].ToString() != "") { model.SchoolCon = ds.Tables[0].Rows[0]["SchoolCon"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolLinkMan"] != null && ds.Tables[0].Rows[0]["SchoolLinkMan"].ToString() != "") { model.SchoolLinkMan = ds.Tables[0].Rows[0]["SchoolLinkMan"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolLinkAddress"] != null && ds.Tables[0].Rows[0]["SchoolLinkAddress"].ToString() != "") { model.SchoolLinkAddress = ds.Tables[0].Rows[0]["SchoolLinkAddress"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolCardInfo"] != null && ds.Tables[0].Rows[0]["SchoolCardInfo"].ToString() != "") { model.SchoolCardInfo = ds.Tables[0].Rows[0]["SchoolCardInfo"].ToString(); } if (ds.Tables[0].Rows[0]["SchoolInterfaceInfo"] != null && ds.Tables[0].Rows[0]["SchoolInterfaceInfo"].ToString() != "") { model.SchoolInterfaceInfo = ds.Tables[0].Rows[0]["SchoolInterfaceInfo"].ToString(); } if (ds.Tables[0].Rows[0]["FbPerson"] != null && ds.Tables[0].Rows[0]["FbPerson"].ToString() != "") { model.FbPerson = ds.Tables[0].Rows[0]["FbPerson"].ToString(); } if (ds.Tables[0].Rows[0]["FbTime"] != null && ds.Tables[0].Rows[0]["FbTime"].ToString() != "") { model.FbTime = DateTime.Parse(ds.Tables[0].Rows[0]["FbTime"].ToString()); } if (ds.Tables[0].Rows[0]["SolveTime"] != null && ds.Tables[0].Rows[0]["SolveTime"].ToString() != "") { model.SolveTime = DateTime.Parse(ds.Tables[0].Rows[0]["SolveTime"].ToString()); } if (ds.Tables[0].Rows[0]["SolveWay"] != null && ds.Tables[0].Rows[0]["SolveWay"].ToString() != "") { model.SolveWay = ds.Tables[0].Rows[0]["SolveWay"].ToString(); } if (ds.Tables[0].Rows[0]["ProblemType"] != null && ds.Tables[0].Rows[0]["ProblemType"].ToString() != "") { model.ProblemType = int.Parse(ds.Tables[0].Rows[0]["ProblemType"].ToString()); } if (ds.Tables[0].Rows[0]["FbDescribe"] != null && ds.Tables[0].Rows[0]["FbDescribe"].ToString() != "") { model.FbDescribe = ds.Tables[0].Rows[0]["FbDescribe"].ToString(); } if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["SolveLoginId"] != null && ds.Tables[0].Rows[0]["SolveLoginId"].ToString() != "") { model.SolveLoginId = ds.Tables[0].Rows[0]["SolveLoginId"].ToString(); } if (ds.Tables[0].Rows[0]["SolveUserPwd"] != null && ds.Tables[0].Rows[0]["SolveUserPwd"].ToString() != "") { model.SolveUserPwd = ds.Tables[0].Rows[0]["SolveUserPwd"].ToString(); } if (ds.Tables[0].Rows[0]["SolveRemark"] != null && ds.Tables[0].Rows[0]["SolveRemark"].ToString() != "") { model.SolveRemark = ds.Tables[0].Rows[0]["SolveRemark"].ToString(); } if (ds.Tables[0].Rows[0]["SolveUserName"] != null && ds.Tables[0].Rows[0]["SolveUserName"].ToString() != "") { model.SolveUserName = ds.Tables[0].Rows[0]["SolveUserName"].ToString(); } if (ds.Tables[0].Rows[0]["SolveBranchName"] != null && ds.Tables[0].Rows[0]["SolveBranchName"].ToString() != "") { model.SolveBranchName = ds.Tables[0].Rows[0]["SolveBranchName"].ToString(); } if (ds.Tables[0].Rows[0]["MarkBrandName"] != null && ds.Tables[0].Rows[0]["MarkBrandName"].ToString() != "") { model.MarkBrandName = ds.Tables[0].Rows[0]["MarkBrandName"].ToString(); } if (ds.Tables[0].Rows[0]["MarkUserPwd"] != null && ds.Tables[0].Rows[0]["MarkUserPwd"].ToString() != "") { model.MarkUserPwd = ds.Tables[0].Rows[0]["MarkUserPwd"].ToString(); } if (ds.Tables[0].Rows[0]["MarkLoginId"] != null && ds.Tables[0].Rows[0]["MarkLoginId"].ToString() != "") { model.MarkLoginId = ds.Tables[0].Rows[0]["MarkLoginId"].ToString(); } if (ds.Tables[0].Rows[0]["MarkRemark"] != null && ds.Tables[0].Rows[0]["MarkRemark"].ToString() != "") { model.MarkRemark = ds.Tables[0].Rows[0]["MarkRemark"].ToString(); } if (ds.Tables[0].Rows[0]["MarkUserName"] != null && ds.Tables[0].Rows[0]["MarkUserName"].ToString() != "") { model.MarkUserName = ds.Tables[0].Rows[0]["MarkUserName"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AMS.Model.View_CallBackErrorInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update View_CallBackErrorInfo set "); strSql.Append("SchoolNum=@SchoolNum,"); strSql.Append("SchoolName=@SchoolName,"); strSql.Append("SchoolDTUip=@SchoolDTUip,"); strSql.Append("SchoolDescribe=@SchoolDescribe,"); strSql.Append("SchoolCon=@SchoolCon,"); strSql.Append("SchoolLinkMan=@SchoolLinkMan,"); strSql.Append("SchoolLinkAddress=@SchoolLinkAddress,"); strSql.Append("SchoolCardInfo=@SchoolCardInfo,"); strSql.Append("SchoolInterfaceInfo=@SchoolInterfaceInfo,"); strSql.Append("FbPerson=@FbPerson,"); strSql.Append("FbTime=@FbTime,"); strSql.Append("SolveTime=@SolveTime,"); strSql.Append("SolveWay=@SolveWay,"); strSql.Append("ProblemType=@ProblemType,"); strSql.Append("FbDescribe=@FbDescribe,"); strSql.Append("ID=@ID,"); strSql.Append("SolveLoginId=@SolveLoginId,"); strSql.Append("SolveUserPwd=@SolveUserPwd,"); strSql.Append("SolveRemark=@SolveRemark,"); strSql.Append("SolveUserName=@SolveUserName,"); strSql.Append("SolveBranchName=@SolveBranchName,"); strSql.Append("MarkBrandName=@MarkBrandName,"); strSql.Append("MarkUserPwd=@MarkUserPwd,"); strSql.Append("MarkLoginId=@MarkLoginId,"); strSql.Append("MarkRemark=@MarkRemark,"); strSql.Append("MarkUserName=@MarkUserName"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@SchoolNum", SqlDbType.NVarChar, 50), new SqlParameter("@SchoolName", SqlDbType.NVarChar, 30), new SqlParameter("@SchoolDTUip", SqlDbType.NVarChar, 20), new SqlParameter("@SchoolDescribe", SqlDbType.NVarChar, 200), new SqlParameter("@SchoolCon", SqlDbType.NVarChar, 200), new SqlParameter("@SchoolLinkMan", SqlDbType.NVarChar, 300), new SqlParameter("@SchoolLinkAddress", SqlDbType.NVarChar, 300), new SqlParameter("@SchoolCardInfo", SqlDbType.Text), new SqlParameter("@SchoolInterfaceInfo", SqlDbType.Text), new SqlParameter("@FbPerson", SqlDbType.NVarChar, 20), new SqlParameter("@FbTime", SqlDbType.DateTime), new SqlParameter("@SolveTime", SqlDbType.DateTime), new SqlParameter("@SolveWay", SqlDbType.NVarChar, 500), new SqlParameter("@ProblemType", SqlDbType.Int, 4), new SqlParameter("@FbDescribe", SqlDbType.NVarChar, 500), new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@SolveLoginId", SqlDbType.NVarChar, 30), new SqlParameter("@SolveUserPwd", SqlDbType.NVarChar, 30), new SqlParameter("@SolveRemark", SqlDbType.NVarChar, 50), new SqlParameter("@SolveUserName", SqlDbType.NVarChar, 30), new SqlParameter("@SolveBranchName", SqlDbType.NVarChar, 30), new SqlParameter("@MarkBrandName", SqlDbType.NVarChar, 30), new SqlParameter("@MarkUserPwd", SqlDbType.NVarChar, 30), new SqlParameter("@MarkLoginId", SqlDbType.NVarChar, 30), new SqlParameter("@MarkRemark", SqlDbType.NVarChar, 50), new SqlParameter("@MarkUserName", SqlDbType.NVarChar, 30) }; parameters[0].Value = model.SchoolNum; parameters[1].Value = model.SchoolName; parameters[2].Value = model.SchoolDTUip; parameters[3].Value = model.SchoolDescribe; parameters[4].Value = model.SchoolCon; parameters[5].Value = model.SchoolLinkMan; parameters[6].Value = model.SchoolLinkAddress; parameters[7].Value = model.SchoolCardInfo; parameters[8].Value = model.SchoolInterfaceInfo; parameters[9].Value = model.FbPerson; parameters[10].Value = model.FbTime; parameters[11].Value = model.SolveTime; parameters[12].Value = model.SolveWay; parameters[13].Value = model.ProblemType; parameters[14].Value = model.FbDescribe; parameters[15].Value = model.ID; parameters[16].Value = model.SolveLoginId; parameters[17].Value = model.SolveUserPwd; parameters[18].Value = model.SolveRemark; parameters[19].Value = model.SolveUserName; parameters[20].Value = model.SolveBranchName; parameters[21].Value = model.MarkBrandName; parameters[22].Value = model.MarkUserPwd; parameters[23].Value = model.MarkLoginId; parameters[24].Value = model.MarkRemark; parameters[25].Value = model.MarkUserName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }