using System;
using System.Collections.Generic;
using System.Text;

namespace SQLHelper
{
    public class ClsSQLEdit
    {
        public string sSQL_Table;
        public string sSQL_Filed;
        public string sSQL_Value;
        public string sSQL_Last;

        public void set_BeginStr(string sTableName)
        {
            sSQL_Table = sTableName;
            sSQL_Filed = "";
            sSQL_Value = "";
            sSQL_Last = "";
        }

        public void set_EndStr()
        {
            if (sSQL_Filed.Trim() == "")
            {
                sSQL_Last = "";
                return;
            }
            else
            {
                sSQL_Filed = sSQL_Filed.Substring(1, sSQL_Filed.Length - 1);
            }
            if (sSQL_Value.Trim() == "")
            {
                sSQL_Last = "";
                return;
            }
            else
            {
                sSQL_Value = sSQL_Value.Substring(1, sSQL_Value.Length - 1);
            }
            sSQL_Last = "Insert into " + sSQL_Table + "(" + sSQL_Filed + ")   values(" + sSQL_Value + ")";
        }


        public void set_AddFiled(string sFiledName,object sFiledValue)
        {
            Type sFiledType;
            sFiledType = sFiledValue.GetType();
            sSQL_Filed = sSQL_Filed + "," + sFiledName;
            //ÅжÏÊý¾ÝÀàÐÍ
            if (sFiledType == Type.GetType("System.Double"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Single"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Int16"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Int32"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Int64"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.Decimal"))
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
            else if (sFiledType == Type.GetType("System.String"))
            {
                if (sFiledValue.ToString().ToLower() == "getdate()")
                {
                    sSQL_Value = sSQL_Value + "," + sFiledValue + "";
                }
                else
                {
                    sSQL_Value = sSQL_Value + ",'" + sFiledValue + "'";
                }
            }
            else if (sFiledType == Type.GetType("System.DateTime"))
            {
                sSQL_Value = sSQL_Value + ",'" + sFiledValue + "'";
            }
            else if (sFiledType == Type.GetType("System.Boolean"))
            {
                if (Pub_Class.ClsPub.isBool(sFiledValue) == true)
                {
                    sSQL_Value = sSQL_Value + ",1";
                }
                else
                {
                    sSQL_Value = sSQL_Value + ",0";
                }

            }
            else
            {
                sSQL_Value = sSQL_Value + "," + sFiledValue;
            }
        }



    }
}