/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCode_InFileImportConfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TCode_InFileImportConfig set "); strSql.Append("s_ConfigName=@s_ConfigName,"); strSql.Append("n_FileNameRule=@n_FileNameRule,"); strSql.Append("n_Delimiter=@n_Delimiter,"); strSql.Append("n_FileType=@n_FileType,"); strSql.Append("s_ImportedFileName=@s_ImportedFileName,"); strSql.Append("n_CaseMethod=@n_CaseMethod,"); strSql.Append("n_FileMethod=@n_FileMethod"); strSql.Append(" where n_ConfigID=@n_ConfigID"); SqlParameter[] parameters = { new SqlParameter("@s_ConfigName", SqlDbType.NVarChar, 100), new SqlParameter("@n_FileNameRule", SqlDbType.Int, 4), new SqlParameter("@n_Delimiter", SqlDbType.Int, 4), new SqlParameter("@n_FileType", SqlDbType.Int, 4), new SqlParameter("@s_ImportedFileName", SqlDbType.NVarChar, 100), new SqlParameter("@n_CaseMethod", SqlDbType.Int, 4), new SqlParameter("@n_FileMethod", SqlDbType.Int, 4), new SqlParameter("@n_ConfigID", SqlDbType.Int, 4) }; parameters[0].Value = model.s_ConfigName; parameters[1].Value = model.n_FileNameRule; parameters[2].Value = model.n_Delimiter; parameters[3].Value = model.n_FileType; parameters[4].Value = model.s_ImportedFileName; parameters[5].Value = model.n_CaseMethod; parameters[6].Value = model.n_FileMethod; parameters[7].Value = model.n_ConfigID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCode_InFileImportConfig DataRowToModel(DataRow row) { IPSP.Model.TCode_InFileImportConfig model = new IPSP.Model.TCode_InFileImportConfig(); if (row != null) { if (row["n_ConfigID"] != null && row["n_ConfigID"].ToString() != "") { model.n_ConfigID = int.Parse(row["n_ConfigID"].ToString()); } if (row["s_ConfigName"] != null) { model.s_ConfigName = row["s_ConfigName"].ToString(); } if (row["n_FileNameRule"] != null && row["n_FileNameRule"].ToString() != "") { model.n_FileNameRule = int.Parse(row["n_FileNameRule"].ToString()); } if (row["n_Delimiter"] != null && row["n_Delimiter"].ToString() != "") { model.n_Delimiter = int.Parse(row["n_Delimiter"].ToString()); } if (row["n_FileType"] != null && row["n_FileType"].ToString() != "") { model.n_FileType = int.Parse(row["n_FileType"].ToString()); } if (row["s_ImportedFileName"] != null) { model.s_ImportedFileName = row["s_ImportedFileName"].ToString(); } if (row["n_CaseMethod"] != null && row["n_CaseMethod"].ToString() != "") { model.n_CaseMethod = int.Parse(row["n_CaseMethod"].ToString()); } if (row["n_FileMethod"] != null && row["n_FileMethod"].ToString() != "") { model.n_FileMethod = int.Parse(row["n_FileMethod"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCode_InFileImportConfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TCode_InFileImportConfig("); strSql.Append("s_ConfigName,n_FileNameRule,n_Delimiter,n_FileType,s_ImportedFileName,n_CaseMethod,n_FileMethod)"); strSql.Append(" values ("); strSql.Append("@s_ConfigName,@n_FileNameRule,@n_Delimiter,@n_FileType,@s_ImportedFileName,@n_CaseMethod,@n_FileMethod)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@s_ConfigName", SqlDbType.NVarChar, 100), new SqlParameter("@n_FileNameRule", SqlDbType.Int, 4), new SqlParameter("@n_Delimiter", SqlDbType.Int, 4), new SqlParameter("@n_FileType", SqlDbType.Int, 4), new SqlParameter("@s_ImportedFileName", SqlDbType.NVarChar, 100), new SqlParameter("@n_CaseMethod", SqlDbType.Int, 4), new SqlParameter("@n_FileMethod", SqlDbType.Int, 4) }; parameters[0].Value = model.s_ConfigName; parameters[1].Value = model.n_FileNameRule; parameters[2].Value = model.n_Delimiter; parameters[3].Value = model.n_FileType; parameters[4].Value = model.s_ImportedFileName; parameters[5].Value = model.n_CaseMethod; parameters[6].Value = model.n_FileMethod; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCode_InFileImportConfig GetModel(int n_ConfigID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 n_ConfigID,s_ConfigName,n_FileNameRule,n_Delimiter,n_FileType,s_ImportedFileName,n_CaseMethod,n_FileMethod from TCode_InFileImportConfig "); strSql.Append(" where n_ConfigID=@n_ConfigID"); SqlParameter[] parameters = { new SqlParameter("@n_ConfigID", SqlDbType.Int, 4) }; parameters[0].Value = n_ConfigID; IPSP.Model.TCode_InFileImportConfig model = new IPSP.Model.TCode_InFileImportConfig(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCode_InFileImportConfig model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCode_InFileImportConfig model) { return(dal.Add(model)); }