Ejemplo n.º 1
0
 private bool DataStore(string strStore)
 {
     if (db.Insert(strStore))
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
Ejemplo n.º 2
0
        public string DataAnalyzeResult(string message)
        {
            message = message.Trim();
            DBManager dbMana      = new DBManager();
            string    analyResult = "";

            GetsqlOrder(message);

            if (sqlOrder == null)
            {
                analyResult = "SOH#00#NO#EOT";
            }
            else
            {
                switch (sqlOrder)
                {
                case "01":
                {
                    if (dbMana.Insert(sqlStr))
                    {
                        analyResult = "SOH#10#OK#EOT";
                    }
                    else
                    {
                        analyResult = "SOH#10#NO#EOT";
                    }
                    break;
                }

                case "02":
                {
                    if (dbMana.Delete(sqlStr))
                    {
                        analyResult = "SOH#20#OK#EOT";
                    }
                    else
                    {
                        analyResult = "SOH#20#NO#EOT";
                    }
                    break;
                }

                case "03":
                {
                    DataTable dt = dbMana.Select(sqlStr);
                    if (dt != null)
                    {
                        string columncount = dt.Columns.Count.ToString();
                        foreach (DataRow row in dt.Rows)        //遍历查询信息
                        {
                            foreach (DataColumn column in dt.Columns)
                            {
                                analyResult = analyResult + column.ColumnName + "%" + row[column].ToString() + "%";
                            }
                        }
                        analyResult = "SOH#30#" + analyResult + columncount + "#EOT";
                    }
                    else
                    {
                        analyResult = "SOH#30#NO#EOT";
                    }
                    break;
                }

                case "04":
                {
                    if (dbMana.Update(sqlStr))
                    {
                        analyResult = "SOH#40#OK#EOT";
                    }
                    else
                    {
                        analyResult = "SOH#40#NO#EOT";
                    }
                    break;
                }

                default:
                    break;
                }
            }

            return(analyResult);
        }