Ejemplo n.º 1
0
        public List <string> GetDrwingsList()
        {
            var           strSql = "SELECT filepath FROM history";
            DataSet       ds     = MysqlDBUtil.Query(strSql);
            List <string> _list  = new List <string>();

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                _list.Add(ds.Tables[0].Rows[i][0].ToString());
            }
            return(_list);
        }
Ejemplo n.º 2
0
        static string getByNewCode(string oldCode)
        {
            string  sql     = "select newcode from code where oldcode='" + oldCode + "'";
            DataSet dataSet = MysqlDBUtil.Query(sql);

            if (dataSet.Tables.Count > 0)
            {
                if (dataSet.Tables[0].Rows.Count > 0)
                {
                    DataRow row = dataSet.Tables[0].Rows[0];
                    return(row["newcode"].ToString());
                }
            }
            return("");
        }
Ejemplo n.º 3
0
        public HistoryDto GetDrwingsDto(string filename)
        {
            HistoryDto dto    = new HistoryDto();
            var        strSql = "SELECT * FROM history WHERE filename='" + filename + "'";
            DataSet    ds     = MysqlDBUtil.Query(strSql);

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                dto.Id         = ds.Tables[0].Rows[i]["id"].ToString();
                dto.FileName   = ds.Tables[0].Rows[i]["filename"].ToString();
                dto.FilePath   = ds.Tables[0].Rows[i]["filepath"].ToString();
                dto.FileStatus = ds.Tables[0].Rows[i]["id"].ToString();
                return(dto);
            }
            return(null);
        }
Ejemplo n.º 4
0
        public void InsertHistory(HistoryDto dto)
        {
            var strSql = "INSERT INTO history(Id,FileName,FileStatus,FilePath) VALUES('" + dto.Id + "','" + dto.FileName + "','" + dto.FileStatus + "','" + dto.FilePath + "')";

            MysqlDBUtil.ExecuteSql(strSql);
        }
Ejemplo n.º 5
0
        public void UpdateHistory(HistoryDto dto)
        {
            var strSql = "UPDATE history SET FileName = '" + dto.FileName + "',FileStatus='" + dto.FileStatus + "',FilePath='" + dto.FilePath + "' WHERE id='" + dto.Id + "'";

            MysqlDBUtil.ExecuteSql(strSql);
        }
Ejemplo n.º 6
0
        public void InsertCode(CodeDto dto)
        {
            var strSql = "INSERT INTO code(Id,oldcode,newcode) VALUES('" + dto.Id + "','" + dto.OldCode + "','" + dto.NewCode + "')";

            MysqlDBUtil.ExecuteSql(strSql);
        }