コード例 #1
0
    public string[] createAidsBrandList(CreateAidsBrand structValue)
    {
        string[] returnValue = new string[2];
        returnValue[0] = "0";
        returnValue[1] = "";
        DataBase Base = new DataBase();
        using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
        {
            try
            {
                StaffDataBase sDB = new StaffDataBase();
                List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
                Sqlconn.Open();
                string sql = "INSERT INTO AidsBrandTable (Category, Brand, CreateFileBy, CreateFileDate, UpFileBy , UpFileDate) " +
                    "VALUES(@Category, @Brand, @CreateFileBy, getDate(), @UpFileBy, getDate() )";
                SqlCommand cmd = new SqlCommand(sql, Sqlconn);
                cmd.Parameters.Add("@Category", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(structValue.brandType);
                cmd.Parameters.Add("@Brand", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(structValue.brandName);
                cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
                cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
                returnValue[0] = cmd.ExecuteNonQuery().ToString();
                Sqlconn.Close();
            }
            catch (Exception e)
            {
                returnValue[0] = "-1";
                returnValue[1] = e.Message;
            }

        }
        return returnValue;
    }
コード例 #2
0
    public string[] setAidsBrandList(CreateAidsBrand structValue)
    {
        string[] returnValue = new string[2];
        returnValue[0] = "0";
        returnValue[1] = "";
        DataBase Base = new DataBase();

        using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
        {
            try
            {
                StaffDataBase sDB            = new StaffDataBase();
                List <string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
                Sqlconn.Open();
                string sql = "UPDATE AidsBrandTable SET  Brand=@Brand, UpFileBy=@UpFileBy, UpFileDate=getDate() " +
                             "WHERE ID=@ID";
                SqlCommand cmd = new SqlCommand(sql, Sqlconn);
                cmd.Parameters.Add("@ID", SqlDbType.Int).Value         = Chk.CheckStringtoIntFunction(structValue.ID);
                cmd.Parameters.Add("@Brand", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(structValue.brandName);
                cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value   = Chk.CheckStringtoIntFunction(CreateFileName[0]);
                returnValue[0] = cmd.ExecuteNonQuery().ToString();
                Sqlconn.Close();
            }
            catch (Exception e)
            {
                returnValue[0] = "-1";
                returnValue[1] = e.Message;
            }
        }
        return(returnValue);
    }
コード例 #3
0
    public string[] createAidsBrandList(CreateAidsBrand structValue)
    {
        string[] returnValue = new string[2];
        returnValue[0] = "0";
        returnValue[1] = "";
        DataBase Base = new DataBase();

        using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
        {
            try
            {
                StaffDataBase sDB            = new StaffDataBase();
                List <string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
                Sqlconn.Open();
                string sql = "INSERT INTO AidsBrandTable (Category, Brand, CreateFileBy, CreateFileDate, UpFileBy , UpFileDate) " +
                             "VALUES(@Category, @Brand, @CreateFileBy, getDate(), @UpFileBy, getDate() )";
                SqlCommand cmd = new SqlCommand(sql, Sqlconn);
                cmd.Parameters.Add("@Category", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(structValue.brandType);
                cmd.Parameters.Add("@Brand", SqlDbType.NVarChar).Value   = Chk.CheckStringFunction(structValue.brandName);
                cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
                cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value     = Chk.CheckStringtoIntFunction(CreateFileName[0]);
                returnValue[0] = cmd.ExecuteNonQuery().ToString();
                Sqlconn.Close();
            }
            catch (Exception e)
            {
                returnValue[0] = "-1";
                returnValue[1] = e.Message;
            }
        }
        return(returnValue);
    }
コード例 #4
0
    public AidsTypestruct getAidsBrandList()
    {
        AidsTypestruct returnValue = new AidsTypestruct();

        returnValue.HearingList = new List <CreateAidsBrand>();
        returnValue.FMList      = new List <CreateAidsBrand>();
        returnValue.eEarList    = new List <CreateAidsBrand>();
        DataBase Base = new DataBase();

        using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
        {
            try
            {
                Sqlconn.Open();
                string        sql = "SELECT * FROM AidsBrandTable ORDER BY ID ";
                SqlCommand    cmd = new SqlCommand(sql, Sqlconn);
                SqlDataReader dr  = cmd.ExecuteReader();
                while (dr.Read())
                {
                    CreateAidsBrand addValue = new CreateAidsBrand();
                    addValue.ID        = dr["ID"].ToString();
                    addValue.brandName = dr["Brand"].ToString();
                    addValue.brandType = dr["Category"].ToString();
                    if (addValue.brandType == "1")
                    {
                        returnValue.HearingList.Add(addValue);
                    }
                    else if (addValue.brandType == "2")
                    {
                        returnValue.eEarList.Add(addValue);
                    }
                    else if (addValue.brandType == "3")
                    {
                        returnValue.FMList.Add(addValue);
                    }
                }
                dr.Close();
                Sqlconn.Close();
            }
            catch (Exception e)
            {
                returnValue.checkNo  = "-1";
                returnValue.errorMsg = e.Message;
            }
        }
        return(returnValue);
    }
コード例 #5
0
    public string[] setAidsBrandList(CreateAidsBrand structValue)
    {
        string[] returnValue = new string[2];
        returnValue[0] = "0";
        returnValue[1] = "";
        DataBase Base = new DataBase();
        using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
        {
            try
            {
                StaffDataBase sDB = new StaffDataBase();
                List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
                Sqlconn.Open();
                string sql = "UPDATE AidsBrandTable SET  Brand=@Brand, UpFileBy=@UpFileBy, UpFileDate=getDate() " +
                             "WHERE ID=@ID";
                SqlCommand cmd = new SqlCommand(sql, Sqlconn);
                cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(structValue.ID);
                cmd.Parameters.Add("@Brand", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(structValue.brandName);
                cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
                returnValue[0] = cmd.ExecuteNonQuery().ToString();
                Sqlconn.Close();
            }
            catch (Exception e)
            {
                returnValue[0] = "-1";
                returnValue[1] = e.Message;
            }

        }
        return returnValue;
    }
コード例 #6
0
    public AidsTypestruct getAidsBrandList()
    {
        AidsTypestruct returnValue = new AidsTypestruct();
        returnValue.HearingList = new List<CreateAidsBrand>();
        returnValue.FMList = new List<CreateAidsBrand>();
        returnValue.eEarList = new List<CreateAidsBrand>();
        DataBase Base = new DataBase();
        using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
        {
            try
            {
                Sqlconn.Open();
                string sql = "SELECT * FROM AidsBrandTable ORDER BY ID ";
                SqlCommand cmd = new SqlCommand(sql, Sqlconn);
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    CreateAidsBrand addValue = new CreateAidsBrand();
                    addValue.ID = dr["ID"].ToString();
                    addValue.brandName = dr["Brand"].ToString();
                    addValue.brandType = dr["Category"].ToString();
                    if (addValue.brandType == "1")
                    {
                        returnValue.HearingList.Add(addValue);
                    }
                    else if (addValue.brandType == "2")
                    {
                        returnValue.eEarList.Add(addValue);
                    }
                    else if (addValue.brandType == "3")
                    {
                        returnValue.FMList.Add(addValue);
                    }

                }
                dr.Close();
                Sqlconn.Close();
            }
            catch (Exception e)
            {
                returnValue.checkNo = "-1";
                returnValue.errorMsg = e.Message;
            }
        }
        return returnValue;
    }
コード例 #7
0
 public string[] setAidsBrandList(CreateAidsBrand structValue)
 {
     ManageDataBase mDB = new ManageDataBase();
     return mDB.setAidsBrandList(structValue);
 }