using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class UnitGJAdd : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string ID = Request.QueryString["ID"];
readGJUnit(ID);
}
protected void readGJUnit(string ID)
{
SqlConnection Conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction);
Conn.Open();
string strSql="SELECT top 1 * FROM [AS_UnitInfo] ORDER BY ID DESC";
SqlCommand cmd = new SqlCommand(strSql,Conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read()) //使用while循环，表示从头一直查找到尾
{
this.txtAS_FacName.Text = dr["AS_FacName"].ToString();
this.txtAS_ContactEmail .Text= dr["AS_ContactEmail"].ToString();
this.txtAS_ContactFax.Text = dr["AS_ContactFax"].ToString();
this.txtAS_ContactMobile.Text = dr["AS_ContactMobile"].ToString();
this.txtAS_ContactPots.Text = dr["AS_ContactPots"].ToString();
this.txtAS_ContactTel.Text = dr["AS_ContactTel"].ToString();
this .txtAS_FactoryPicture.Text=dr["AS_FactoryPicture"].ToString();
this .txtAS_History.Text=dr["AS_History"].ToString();
this.txtAS_Leadorship.Text = dr["AS_Leadorship"].ToString();
this .txtAS_ProductInfo.Text=dr["AS_ProductInfo"].ToString();
this.txtAS_ProductStructure.Text = dr["AS_ProductStructure"].ToString();
this.txtAS_ProductTeam.Text = dr["AS_ProductTeam"].ToString();
this.txtAS_ResearchPicture.Text = dr["AS_ResearchPicture"].ToString();
this.txtAS_ResearchTeam.Text = dr["AS_ResearchTeam"].ToString();
this.txtAS_SaleMode.Text = dr["AS_SaleMode"].ToString();
this .txtAS_SaleTeam.Text=dr["AS_SaleTeam"].ToString();
this.txtAS_YearSales.Text = dr["AS_YearSales"].ToString();
this.txtAS_Yield.Text = dr["AS_Yield"].ToString();
this.hidUnitID.Value = ID;
}
dr.Close();
cmd.Dispose();
Conn.Close();
}
protected void saveGJUnit()
{
string strUnitID = this.hidUnitID.Value;
string strAS_ContactEmail = this.txtAS_ContactEmail.Text;
string strAS_Contact = this.txtAS_Contact.Text;
string strAS_ContactFax= this.txtAS_ContactFax.Text;
string strAS_ContactMobile= this.txtAS_ContactMobile.Text;
string strAS_ContactPots = this.txtAS_ContactPots.Text;
string strAS_ContactTel = this.txtAS_ContactTel.Text;
string strAS_FactoryPicture = this.txtAS_FactoryPicture.Text;
string strAS_History = this.txtAS_History.Text;
string strAS_Leadorship = this.txtAS_Leadorship.Text;
string strAS_ProductInfo = this.txtAS_ProductInfo.Text;
string strAS_ProductStructure = this.txtAS_ProductStructure.Text;
string strAS_ProductTeam = this.txtAS_ProductTeam.Text;
string strAS_ResearchPicture = this.txtAS_ResearchPicture.Text;
string strAS_ResearchTeam = this.txtAS_ResearchTeam.Text;
string strAS_SaleMode = this.txtAS_SaleMode.Text;
string strAS_SaleTeam = this.txtAS_SaleTeam.Text;
string strAS_YearSales = this.txtAS_YearSales.Text;
string strAS_Yield = this.txtAS_Yield.Text;
string strSql = "UPDATE [AS_UnitInfo] SET";
if (strAS_Contact != "") { strSql += ",AS_Contact='"+strAS_Contact+"'"; }
if (strAS_ContactEmail != "") { strSql += ",AS_ContactEmail='" + strAS_ContactEmail + "'"; }
if (strAS_ContactFax != "") { strSql += ",AS_ContactFax='" + strAS_ContactFax + "'"; }
if (strAS_ContactMobile != "") { strSql += ",AS_ContactMobile='" + strAS_ContactMobile + "'"; }
if (strAS_ContactPots != "") { strSql += ",AS_ContactPots='" + strAS_ContactPots + "'"; }
if (strAS_ContactTel != "") { strSql += ",AS_ContactTel='" + strAS_ContactTel + "'"; }
if (strAS_FactoryPicture != "") { strSql += ",strAS_FactoryPicture='" + strAS_FactoryPicture + "'"; }
if (strAS_History != "") { strSql += ",AS_History='" + strAS_History + "'"; }
if (strAS_Leadorship != "") { strSql += ",AS_Leadorship='" + strAS_Leadorship + "'"; }
if (strAS_ProductInfo != "") { strSql += ",AS_ProductInfo='" + strAS_ProductInfo + "'"; }
if (strAS_ProductStructure != "") { strSql += ",AS_ProductStructure='" + strAS_ProductStructure + "'"; }
if (strAS_ProductTeam != "") { strSql += ",AS_ProductTeam='" + strAS_ProductTeam + "'"; }
if (strAS_ResearchPicture != "") { strSql += ",AS_ResearchPicture='" + strAS_ResearchPicture + "'"; }
if (strAS_SaleMode != "") { strSql += ",AS_SaleMode='" + strAS_SaleMode + "'"; }
if (strAS_SaleTeam != "") { strSql += ",AS_SaleTeam='" + strAS_SaleTeam + "'"; }
if (strAS_YearSales != "") { strSql += ",AS_YearSales='" + strAS_YearSales + "'"; }
if (strAS_Yield != "") { strSql += ",AS_Yield='" + strAS_Yield + "'"; }
strSql = strSql.Replace("SET,", "SET ");
strSql = strSql + " where [ID]=" + strUnitID;
Response.Write(strSql);
Response.End();
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringLocalTransaction))
{
//打开连接
conn.Open();
//调用执行方法，因为没有参数，所以最后一项直接设置为null
//SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql, null);
//strSql += " select @@IDENTITY AS 'ID'";
object myobj = SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql, null);
//return myobj.ToString();
}
}
protected void btnSaveGJUnit_Click(object sender, EventArgs e)
{
saveGJUnit();
}
}
当我直接保存按钮的时候，打印出的sql语句不完整。为什么呢？
