예제 #1
0
파일: ICS_ROLE.cs 프로젝트: ZwPandora/GIL
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(ICS_Role model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update ICS_Role set ");
            if (model.NAME != null)
            {
                strSql.Append("NAME='" + model.NAME + "',");
            }
            if (model.ROLEINFO != null)
            {
                strSql.Append("ROLEINFO='" + model.ROLEINFO + "',");
            }
            if (model.CJR != null)
            {
                strSql.Append("CJR='" + model.CJR + "',");
            }
            if (model.CREATETIME != null)
            {
                strSql.Append("CREATETIME=to_date('" + model.CREATETIME.ToString() + "','YYYY-MM-DD HH24:MI:SS'),");
            }
            int n = strSql.ToString().LastIndexOf(",");

            strSql.Remove(n, 1);
            strSql.Append(" where ID=" + model.ID + " ");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }
예제 #2
0
파일: ICS_ROLE.cs 프로젝트: ZwPandora/GIL
        /// <summary>
        /// 获得数据列表
        /// </summary>
        public List <ICS_Role> GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select ID,NAME,ROLEINFO,CJR,CREATETIME ");
            strSql.Append(" FROM ICS_Role ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            DataSet         ds        = DbHelperSQL.Query(strSql.ToString());
            List <ICS_Role> modelList = new List <ICS_Role>();

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                ICS_Role model = new ICS_Role();
                if (ds.Tables[0].Rows[i]["ID"].ToString() != "")
                {
                    model.ID = int.Parse(ds.Tables[0].Rows[i]["ID"].ToString());
                }
                model.NAME     = ds.Tables[0].Rows[i]["NAME"].ToString();
                model.ROLEINFO = ds.Tables[0].Rows[i]["ROLEINFO"].ToString();
                model.CJR      = ds.Tables[0].Rows[i]["CJR"].ToString();
                if (ds.Tables[0].Rows[i]["CREATETIME"].ToString() != "")
                {
                    model.CREATETIME = DateTime.Parse(ds.Tables[0].Rows[i]["CREATETIME"].ToString());
                }
                modelList.Add(model);
            }
            return(modelList);
        }
예제 #3
0
파일: ICS_ROLE.cs 프로젝트: ZwPandora/GIL
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public ICS_Role GetModel(int ID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  ");
            strSql.Append(" ID,NAME,ROLEINFO,CJR,CREATETIME ");
            strSql.Append(" from ICS_Role ");
            strSql.Append(" where ID=" + ID + " ");
            ICS_Role model = new ICS_Role();
            DataSet  ds    = DbHelperSQL.Query(strSql.ToString());

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
                {
                    model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
                }
                model.NAME     = ds.Tables[0].Rows[0]["NAME"].ToString();
                model.ROLEINFO = ds.Tables[0].Rows[0]["ROLEINFO"].ToString();
                model.CJR      = ds.Tables[0].Rows[0]["CJR"].ToString();
                if (ds.Tables[0].Rows[0]["CREATETIME"].ToString() != "")
                {
                    model.CREATETIME = DateTime.Parse(ds.Tables[0].Rows[0]["CREATETIME"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
예제 #4
0
파일: ICS_ROLE.cs 프로젝트: ZwPandora/GIL
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(ICS_Role model)
        {
            model.ID = GetMaxId() + 1;
            StringBuilder strSql  = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();

            strSql1.Append("ID,");
            strSql2.Append("" + model.ID + ",");
            if (model.NAME != null)
            {
                strSql1.Append("NAME,");
                strSql2.Append("'" + model.NAME + "',");
            }
            if (model.ROLEINFO != null)
            {
                strSql1.Append("ROLEINFO,");
                strSql2.Append("'" + model.ROLEINFO + "',");
            }
            if (model.CJR != null)
            {
                strSql1.Append("CJR,");
                strSql2.Append("'" + model.CJR + "',");
            }
            if (model.CREATETIME != null)
            {
                strSql1.Append("CREATETIME,");
                strSql2.Append("to_date('" + model.CREATETIME.ToString() + "','YYYY-MM-DD HH24:MI:SS'),");
            }
            strSql.Append("insert into ics_ROLE(");
            strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }
예제 #5
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(ICS_Role model)
 {
     dal.Update(model);
 }
예제 #6
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public void Add(ICS_Role model)
 {
     dal.Add(model);
 }