GoodMenhod/tb_CompanyMenthod.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using CHEXC.ClassInfo;
using System.Windows.Forms;
namespace CHEXC.GoodMenhod
{
    public class tb_CompanyMenthod
    {
        SqlConnection conn = null;
        SqlCommand cmd = null;
        SqlDataReader qlddr = null;
               
        #region 添加
        public int tb_CompanyMenthodAdd(tb_Company Company)
        {
            int intFalg = 0;
            try
            {
                string str_Add = "insert into tb_Company values( ";
              str_Add+="'"+Company.intCompanyID+"','"+Company.strCompanyName+"','"+Company.strCompanyDirector+"',";
               str_Add+="'"+Company.strCompanyPhone+"','"+Company.strCompanyFax+"','"+Company.strCompanyAddress+"',";
                              str_Add+="'"+Company.strCompanyRemark+"','"+Company.daReDateTime+"','"+Company.intEmpFalg+"')";
              getSqlConnection getConnection = new getSqlConnection();
              conn = getConnection.GetCon();
              cmd = new SqlCommand(str_Add,conn);
              intFalg = cmd.ExecuteNonQuery();
              conn.Dispose();
              return intFalg;

            
            }
            catch (Exception ee)
            {
                return intFalg;
                
            }

        }
        #endregion
        #region 修改
        public int tb_CompanyMenthodUpDate(tb_Company Company)
        {
            int intFalg = 0;
            try
            {
                string str_Add = "update tb_Company  set ";
                str_Add += "CompanyName='" + Company.strCompanyName + "',CompanyDirector='" + Company.strCompanyDirector + "',";
                str_Add += "CompanyPhone='" + Company.strCompanyPhone + "',CompanyFax='" + Company.strCompanyFax + "',CompanyAddress='" + Company.strCompanyAddress + "',";
                str_Add += "CompanyRemark='" + Company.strCompanyRemark + "',ReDateTime='" + Company.daReDateTime + "',Falg='" + Company.intEmpFalg + "' where CompanyID ='" + Company.intCompanyID + "'";
               
              
                getSqlConnection getConnection = new getSqlConnection();
                conn = getConnection.GetCon();
                cmd = new SqlCommand(str_Add, conn);
                intFalg = cmd.ExecuteNonQuery();
                conn.Dispose();
                return intFalg;