/// <summary> /// 查询合同单位分组表 /// </summary> /// <returns></returns> public ArrayList GetCpackunitstat() { ArrayList List = null; string strSql = ""; if (this.Sql.GetSql("Fee.Cpactunitstat.GetCpackunitstat", ref strSql) == -1) { return(null); } try { this.ExecQuery(strSql); Neusoft.HISFC.Models.Fee.PactStat info = null; List = new ArrayList(); while (this.Reader.Read()) { info = new Neusoft.HISFC.Models.Fee.PactStat(); info.ID = Reader[0].ToString(); info.Name = Reader[1].ToString(); info.ID = Reader[2].ToString(); info.Name = Reader[3].ToString(); //info. =Reader[4].ToString(); //info.WBCode = Reader[5].ToString(); //info.InputCode =Reader[6].ToString(); if (Reader[7] != DBNull.Value) { info.SortId = Convert.ToInt32(Reader[7]); } string Temp = Reader[8].ToString(); if (Temp == "0") { info.ValidState = "在用"; } else if (Temp == "1") { info.ValidState = "停用"; } else if (Temp == "2") { info.ValidState = "废弃"; } else { info.ValidState = ""; } List.Add(info); info = null; } } catch (Exception ee) { this.Err = ee.Message; return(null); } return(List); }
/// <summary> /// 更新合同单位分组表 /// </summary> /// <param name="info"></param> /// <returns></returns> public int UpdateCpackunitstat(Neusoft.HISFC.Models.Fee.PactStat info) { string strSql = ""; if (this.Sql.GetSql("Fee.Cpactunitstat.UpdateCpackunitstat", ref strSql) == -1) { return(-1); } try { string OperId = this.Operator.ID; //UPDATE com_pactunitstat set (group_name = '{1}', pact_code ='{2}' , spell_code ='{3}', wb_code ='{4}',input_code ='{5}', SORT_ID ={6}, VALID_STATE ='{7}', OPER_CODE ='{8}' , oper_date =sysdate ) where GROUP_ID ='{0}' and parent_code = '[父级编码]' and current_code ='[本级编码]' strSql = string.Format(strSql, info.ID, info.Name, info.ID, info.SpellCode, info.WBCode, info.UserCode, info.SortId, info.ValidState, OperId); } catch (Exception ee) { this.Err = ee.Message; return(-1); } return(this.ExecNoQuery(strSql)); }
/// <summary> /// 插入数据 /// </summary> /// <param name="info"></param> /// <returns></returns> public int InsertCpackunitstat(Neusoft.HISFC.Models.Fee.PactStat info) { string strSql = ""; if (this.Sql.GetSql("Fee.Cpactunitstat.InsertCpackunitstat", ref strSql) == -1) { return(-1); } try { //insert into com_pactunitstat values ('[父级编码]','[本级编码]' ,'{0}', '{1}','{2}' ,'{3}' ,'{4}' ,'{5}' ,{6} , '{7}','{8}',sysdate) string OperId = this.Operator.ID; strSql = string.Format(strSql, info.ID, info.Name, info.ID, info.SpellCode, info.WBCode, info.UserCode, info.SortId, info.ValidState, OperId); } catch (Exception ee) { this.Err = ee.Message; return(-1); } return(this.ExecNoQuery(strSql)); }