/// <summary> /// 更新一条数据 /// </summary> public bool Update(IPSP.Model.TCode_FlowNoRule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TCode_FlowNoRule set "); strSql.Append("s_IPType=@s_IPType,"); strSql.Append("s_FlowNoRelate1=@s_FlowNoRelate1,"); strSql.Append("s_FlowNoRelate2=@s_FlowNoRelate2,"); strSql.Append("s_FlowNoRule=@s_FlowNoRule,"); strSql.Append("s_FlowNoType=@s_FlowNoType,"); strSql.Append("n_MaxNo=@n_MaxNo,"); strSql.Append("s_ResetEachYear=@s_ResetEachYear,"); strSql.Append("n_FlowNoCount=@n_FlowNoCount,"); strSql.Append("s_OneTrademarkOneFlow=@s_OneTrademarkOneFlow"); strSql.Append(" where n_ID=@n_ID"); SqlParameter[] parameters = { new SqlParameter("@s_IPType", SqlDbType.NVarChar, 1), new SqlParameter("@s_FlowNoRelate1", SqlDbType.NVarChar, 50), new SqlParameter("@s_FlowNoRelate2", SqlDbType.NVarChar, 50), new SqlParameter("@s_FlowNoRule", SqlDbType.NVarChar, 1), new SqlParameter("@s_FlowNoType", SqlDbType.NVarChar, 200), new SqlParameter("@n_MaxNo", SqlDbType.Int, 4), new SqlParameter("@s_ResetEachYear", SqlDbType.NVarChar, 1), new SqlParameter("@n_FlowNoCount", SqlDbType.Int, 4), new SqlParameter("@s_OneTrademarkOneFlow", SqlDbType.NVarChar, 1), new SqlParameter("@n_ID", SqlDbType.Int, 4) }; parameters[0].Value = model.s_IPType; parameters[1].Value = model.s_FlowNoRelate1; parameters[2].Value = model.s_FlowNoRelate2; parameters[3].Value = model.s_FlowNoRule; parameters[4].Value = model.s_FlowNoType; parameters[5].Value = model.n_MaxNo; parameters[6].Value = model.s_ResetEachYear; parameters[7].Value = model.n_FlowNoCount; parameters[8].Value = model.s_OneTrademarkOneFlow; parameters[9].Value = model.n_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCode_FlowNoRule DataRowToModel(DataRow row) { IPSP.Model.TCode_FlowNoRule model = new IPSP.Model.TCode_FlowNoRule(); if (row != null) { if (row["n_ID"] != null && row["n_ID"].ToString() != "") { model.n_ID = int.Parse(row["n_ID"].ToString()); } if (row["s_IPType"] != null) { model.s_IPType = row["s_IPType"].ToString(); } if (row["s_FlowNoRelate1"] != null) { model.s_FlowNoRelate1 = row["s_FlowNoRelate1"].ToString(); } if (row["s_FlowNoRelate2"] != null) { model.s_FlowNoRelate2 = row["s_FlowNoRelate2"].ToString(); } if (row["s_FlowNoRule"] != null) { model.s_FlowNoRule = row["s_FlowNoRule"].ToString(); } if (row["s_FlowNoType"] != null) { model.s_FlowNoType = row["s_FlowNoType"].ToString(); } if (row["n_MaxNo"] != null && row["n_MaxNo"].ToString() != "") { model.n_MaxNo = int.Parse(row["n_MaxNo"].ToString()); } if (row["s_ResetEachYear"] != null) { model.s_ResetEachYear = row["s_ResetEachYear"].ToString(); } if (row["n_FlowNoCount"] != null && row["n_FlowNoCount"].ToString() != "") { model.n_FlowNoCount = int.Parse(row["n_FlowNoCount"].ToString()); } if (row["s_OneTrademarkOneFlow"] != null) { model.s_OneTrademarkOneFlow = row["s_OneTrademarkOneFlow"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCode_FlowNoRule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TCode_FlowNoRule("); strSql.Append("s_IPType,s_FlowNoRelate1,s_FlowNoRelate2,s_FlowNoRule,s_FlowNoType,n_MaxNo,s_ResetEachYear,n_FlowNoCount,s_OneTrademarkOneFlow)"); strSql.Append(" values ("); strSql.Append("@s_IPType,@s_FlowNoRelate1,@s_FlowNoRelate2,@s_FlowNoRule,@s_FlowNoType,@n_MaxNo,@s_ResetEachYear,@n_FlowNoCount,@s_OneTrademarkOneFlow)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@s_IPType", SqlDbType.NVarChar, 1), new SqlParameter("@s_FlowNoRelate1", SqlDbType.NVarChar, 50), new SqlParameter("@s_FlowNoRelate2", SqlDbType.NVarChar, 50), new SqlParameter("@s_FlowNoRule", SqlDbType.NVarChar, 1), new SqlParameter("@s_FlowNoType", SqlDbType.NVarChar, 200), new SqlParameter("@n_MaxNo", SqlDbType.Int, 4), new SqlParameter("@s_ResetEachYear", SqlDbType.NVarChar, 1), new SqlParameter("@n_FlowNoCount", SqlDbType.Int, 4), new SqlParameter("@s_OneTrademarkOneFlow", SqlDbType.NVarChar, 1) }; parameters[0].Value = model.s_IPType; parameters[1].Value = model.s_FlowNoRelate1; parameters[2].Value = model.s_FlowNoRelate2; parameters[3].Value = model.s_FlowNoRule; parameters[4].Value = model.s_FlowNoType; parameters[5].Value = model.n_MaxNo; parameters[6].Value = model.s_ResetEachYear; parameters[7].Value = model.n_FlowNoCount; parameters[8].Value = model.s_OneTrademarkOneFlow; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IPSP.Model.TCode_FlowNoRule GetModel(int n_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 n_ID,s_IPType,s_FlowNoRelate1,s_FlowNoRelate2,s_FlowNoRule,s_FlowNoType,n_MaxNo,s_ResetEachYear,n_FlowNoCount,s_OneTrademarkOneFlow from TCode_FlowNoRule "); strSql.Append(" where n_ID=@n_ID"); SqlParameter[] parameters = { new SqlParameter("@n_ID", SqlDbType.Int, 4) }; parameters[0].Value = n_ID; IPSP.Model.TCode_FlowNoRule model = new IPSP.Model.TCode_FlowNoRule(); 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_FlowNoRule model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(IPSP.Model.TCode_FlowNoRule model) { return(dal.Add(model)); }