/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCode_CPCTemplate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TCode_CPCTemplate set "); strSql.Append("s_Code=@s_Code,"); strSql.Append("s_ListXmlType=@s_ListXmlType,"); strSql.Append("s_IsCanCoding=@s_IsCanCoding,"); strSql.Append("s_IsCanImport=@s_IsCanImport,"); strSql.Append("s_ImpotFileType=@s_ImpotFileType,"); strSql.Append("s_NeedCameOFile=@s_NeedCameOFile"); strSql.Append(" where n_ID=@n_ID"); SqlParameter[] parameters = { new SqlParameter("@s_Code", SqlDbType.NVarChar, 10), new SqlParameter("@s_ListXmlType", SqlDbType.NVarChar, 1), new SqlParameter("@s_IsCanCoding", SqlDbType.NVarChar, 1), new SqlParameter("@s_IsCanImport", SqlDbType.NVarChar, 1), new SqlParameter("@s_ImpotFileType", SqlDbType.NVarChar, 100), new SqlParameter("@s_NeedCameOFile", SqlDbType.NVarChar, 1), new SqlParameter("@n_ID", SqlDbType.Int, 4) }; parameters[0].Value = model.s_Code; parameters[1].Value = model.s_ListXmlType; parameters[2].Value = model.s_IsCanCoding; parameters[3].Value = model.s_IsCanImport; parameters[4].Value = model.s_ImpotFileType; parameters[5].Value = model.s_NeedCameOFile; parameters[6].Value = model.n_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCode_CPCTemplate model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TCode_CPCTemplate("); strSql.Append("s_Code,s_ListXmlType,s_IsCanCoding,s_IsCanImport,s_ImpotFileType,s_NeedCameOFile)"); strSql.Append(" values ("); strSql.Append("@s_Code,@s_ListXmlType,@s_IsCanCoding,@s_IsCanImport,@s_ImpotFileType,@s_NeedCameOFile)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@s_Code", SqlDbType.NVarChar, 10), new SqlParameter("@s_ListXmlType", SqlDbType.NVarChar, 1), new SqlParameter("@s_IsCanCoding", SqlDbType.NVarChar, 1), new SqlParameter("@s_IsCanImport", SqlDbType.NVarChar, 1), new SqlParameter("@s_ImpotFileType", SqlDbType.NVarChar, 100), new SqlParameter("@s_NeedCameOFile", SqlDbType.NVarChar, 1) }; parameters[0].Value = model.s_Code; parameters[1].Value = model.s_ListXmlType; parameters[2].Value = model.s_IsCanCoding; parameters[3].Value = model.s_IsCanImport; parameters[4].Value = model.s_ImpotFileType; parameters[5].Value = model.s_NeedCameOFile; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCode_CPCTemplate DataRowToModel(DataRow row) { IPSP.Model.TCode_CPCTemplate model = new IPSP.Model.TCode_CPCTemplate(); if (row != null) { if (row["n_ID"] != null && row["n_ID"].ToString() != "") { model.n_ID = int.Parse(row["n_ID"].ToString()); } if (row["s_Code"] != null) { model.s_Code = row["s_Code"].ToString(); } if (row["s_ListXmlType"] != null) { model.s_ListXmlType = row["s_ListXmlType"].ToString(); } if (row["s_IsCanCoding"] != null) { model.s_IsCanCoding = row["s_IsCanCoding"].ToString(); } if (row["s_IsCanImport"] != null) { model.s_IsCanImport = row["s_IsCanImport"].ToString(); } if (row["s_ImpotFileType"] != null) { model.s_ImpotFileType = row["s_ImpotFileType"].ToString(); } if (row["s_NeedCameOFile"] != null) { model.s_NeedCameOFile = row["s_NeedCameOFile"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCode_CPCTemplate GetModel(int n_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 n_ID,s_Code,s_ListXmlType,s_IsCanCoding,s_IsCanImport,s_ImpotFileType,s_NeedCameOFile from TCode_CPCTemplate "); strSql.Append(" where n_ID=@n_ID"); SqlParameter[] parameters = { new SqlParameter("@n_ID", SqlDbType.Int, 4) }; parameters[0].Value = n_ID; IPSP.Model.TCode_CPCTemplate model = new IPSP.Model.TCode_CPCTemplate(); 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_CPCTemplate model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCode_CPCTemplate model) { return(dal.Add(model)); }