在ASP.NET中添加含税的itemdetails [英] Add itemdetails with tax in ASP.NET

查看：63 发布时间：2019/6/21 3:00:53 ASP.NET

本文介绍了在ASP.NET中添加含税的itemdetails的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AddItemDetails.aspx.cs" Inherits="AddItemDetails" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head  runat="server">
    <title></title>
    <link href="css/MasterStyle.css" rel="Stylesheet" type="text/css" />
    <style type="text/css">
        .style4
        {
            width: 100%;
        }
        .style5
        {
            width: 37px;
        }
        .style6
        {
            width: 131px;
        }
        .style7
        {
            width:150px;
        }
    </style>
</head>
<body>
 
   
<div id="iFrame">
    <form id="form1"  runat="server">
    <asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server"/>
    <div class="iFrameHeader">
    <asp:Label ID ="lblPage" Text="Add Item Details" runat="server">
    <hr />
    </div>
    <asp:TabContainer ID="TabContainer1" runat="server">
    <asp:TabPanel ID="tbPanel" HeaderText="Add Items" runat="server">
    <contenttemplate>
    <table class="style4">
        <tr>
            <td class="style5">
                <asp:Label ID="lblItemType" runat="server" Font-Bold="True" Text="Item Type">
            </td>
            <td class="style6">
                <asp:DropDownList ID="ddlItemType" runat="server" DataSourceID="sdlItemtype" 

                    DataTextField="Item_Type_Name" DataValueField="Item_Type_Id">
                
                <asp:SqlDataSource ID="sdlItemtype" runat="server" 

                    ConnectionString="<%$ ConnectionStrings:IMS %>" 

                    SelectCommand="SELECT [Item_Type_Id], [Item_Type_Name] FROM [ItemType]">
                
            </td>
            <td class="style7">
                 </td>
            <td class="style7">
                <asp:Label ID="lblMake" runat="server" Font-Bold="True" Text="Make">
            </td>
            <td>
                <asp:TextBox ID="txtMake" runat="server" CssClass="inputtxt" Height="32px">
                <asp:AutoCompleteExtender ID="txtMake_AutoCompleteExtender" runat="server"  MinimumPrefixLength="0" CompletionInterval="100"

                    DelimiterCharacters="" Enabled="True" ServicePath="~/AutoComplte.asmx" ServiceMethod="Make" TargetControlID="txtMake">
                
                
            </td>
        </tr>
        <tr>
            <td class="style5">
                 </td>
            <td class="style6">
                 </td>
            <td class="style7">
                 </td>
            <td class="style7">
                 </td>
            <td><asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat ="server" 

                    ControlToValidate="txtMake" Display="Dynamic" 

                    ErrorMessage="Please Enter Make" 

                    Font-Size="X-Small">
                 </td>
        </tr>
        <tr>
            <td class="style5">
                <asp:Label ID="ldlItemDescription" runat="server" Font-Bold="True" 

                    Text="Item Description">
            </td>
            <td class="style6">
                <asp:TextBox ID="txtItemDescription" runat="server" Height="45px" 

                    TextMode="MultiLine" Width="142px" CssClass="inputtxt">
                <asp:AutoCompleteExtender ID="txtItemDescription_AutoCompleteExtender" 

                    runat="server" DelimiterCharacters="" Enabled="True" ServicePath="~/AutoComplte.asmx" CompletionInterval="100" MinimumPrefixLength="0" ServiceMethod="GetCompletionList"

                    TargetControlID="txtItemDescription">
                
            </td>
            <td class="style7">
                 </td>
            <td class="style7">
                <asp:Label ID="lblSupplier" runat="server" Font-Bold="True" Text="Supplier">
            </td>
            <td>
                <asp:TextBox ID="txtSupplier" runat="server" Height="42px" TextMode="MultiLine" 

                    Width="134px" CssClass="inputtxt">
                <asp:AutoCompleteExtender ID="txtSupplier_AutoCompleteExtender" runat="server" 

                    DelimiterCharacters="" Enabled="True" ServicePath="~/AutoComplte.asmx" CompletionInterval="100" MinimumPrefixLength="0" ServiceMethod="suppliername"

                    TargetControlID="txtSupplier">
                
            </td>
        </tr>
        <tr>
            <td class="style5">
                <asp:Label ID="LblPrice1" runat="server" Font-Bold="True" Text="Price(1-100)" Width="100px">
            </td>
            <td class="style6">
                <asp:TextBox ID="txtPrice1" runat="server" CssClass="inputtxt">
                <asp:FilteredTextBoxExtender ID="txtPrice1_FilteredTextBoxExtender" 

                    runat="server" Enabled="True" TargetControlID="txtPrice1" ValidChars="." 

                    FilterType="Custom, Numbers">
                
                <asp:RequiredFieldValidator ID="range1" runat ="server" 

                    ControlToValidate="txtPrice1" Display="Dynamic" 

                    ErrorMessage="Please Enter value (1-100)" 

                    Font-Size="X-Small">
                <asp:RangeValidator ID="rnge1" runat ="server" ControlToValidate="txtPrice1" 

                    Display="Dynamic" ErrorMessage="The value must be from 1 to 100!"" 

                    Font-Size="X-Small" MaximumValue="100" MinimumValue="1" 

                    EnableClientScript="False" Type="Integer">
            </td>
            <td class="style7">
                 </td>
            <td class="style7">
                <asp:Label ID="Label8" runat="server" Font-Bold="True" Text="price(101-1000)" Width="150px">
            </td>
            <td>
                <asp:TextBox ID="txtprice2" runat="server" CssClass="inputtxt">
                <asp:FilteredTextBoxExtender ID="txtprice2_FilteredTextBoxExtender" 

                    runat="server" Enabled="True" TargetControlID="txtprice2" ValidChars="." 

                    FilterType="Custom, Numbers">
                
                  </td>
        </tr>
        <tr>
            <td class="style5">
                 </td>
            <td class="style6">
                 </td>
            <td class="style7">
                 </td>
            <td class="style7">
                 </td>
            <td><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat ="server" 

                    ControlToValidate="txtprice2" Display="Dynamic" 

                    ErrorMessage="Please Enter value (101-1000)" 

                    Font-Size="X-Small">
                <asp:RangeValidator ID="RangeValidator3" runat ="server" ControlToValidate="txtPrice2" 

                    Display="Dynamic" ErrorMessage="The value must be from 101 to 1000!"" 

                    Font-Size="X-Small" MaximumValue="1000" MinimumValue="101" 

                    EnableClientScript="False" Type="Integer">
                 </td>
        </tr>
        <tr>
            <td class="style5">
                <asp:Label ID="Label4" runat="server" Font-Bold="True" Text="price(1001-10000)" 

                    Width="160px">
            </td>
            <td class="style6">
                <asp:TextBox ID="txtPrice3" runat="server" CssClass="inputtxt">
                <asp:FilteredTextBoxExtender ID="txtPrice3_FilteredTextBoxExtender" 

                    runat="server" Enabled="True" TargetControlID="txtPrice3"  ValidChars="." 

                    FilterType="Custom, Numbers">
                
                <asp:RequiredFieldValidator ID="Reqp3" runat ="server" 

                    ControlToValidate="txtprice3" Display="Dynamic" 

                    ErrorMessage="Please Enter value (1001-10000)" 

                    Font-Size="X-Small">
                <asp:RangeValidator ID="Rangp3" runat ="server" ControlToValidate="txtPrice3" 

                    Display="Dynamic" ErrorMessage="The value must be from 101 to 1000!"" 

                    Font-Size="X-Small" MaximumValue="10000" MinimumValue="1001" 

                    EnableClientScript="False" Type="Integer">

            </td>
            <td class="style7">
                 </td>
            <td class="style7">
                <asp:Label ID="Label9" runat="server" Font-Bold="True" 

                    Text="Price(10001-50000)" Width="170px">
            </td>
            <td>
                <asp:TextBox ID="txtprice4" runat="server" CssClass="inputtxt">
                <asp:FilteredTextBoxExtender ID="txtprice4_FilteredTextBoxExtender" 

                    runat="server" Enabled="True" TargetControlID="txtprice4"  ValidChars="." 

                    FilterType="Custom, Numbers">
                
                 
            </td>
        </tr>
        <tr>
            <td class="style5">
                 </td>
            <td class="style6">
                 </td>
            <td class="style7">
                 </td>
            <td class="style7">
                 </td>
            <td><asp:RequiredFieldValidator ID="Reqp4" runat ="server" 

                    ControlToValidate="txtprice4" Display="Dynamic" 

                    ErrorMessage="Please Enter value (10001-50000)" 

                    Font-Size="X-Small">
                <asp:RangeValidator ID="RangeValidator1" runat ="server" ControlToValidate="txtPrice4" 

                    Display="Dynamic" ErrorMessage="The value must be from 10001 to 50000!"" 

                    Font-Size="X-Small" MaximumValue="50000" MinimumValue="10001" 

                    EnableClientScript="False" Type="Integer">
                 </td>
        </tr>
        <tr>
            <td class="style5">
                <asp:Label ID="Label5" runat="server" Font-Bold="True" 

                    Text="Price(50001-100000)" Width="170px">
            </td>
            <td class="style6">
                <asp:TextBox ID="txtprice5" runat="server" CssClass="inputtxt">
                <asp:FilteredTextBoxExtender ID="txtprice5_FilteredTextBoxExtender" 

                    runat="server" Enabled="True" TargetControlID="txtprice5"  ValidChars="." 

                    FilterType="Custom, Numbers">
                
                <asp:RequiredFieldValidator ID="Reqp5" runat ="server" 

                    ControlToValidate="txtprice5" Display="Dynamic" 

                    ErrorMessage="Please Enter value (50001-100000)"  

                    Font-Size="X-Small">
                <asp:RangeValidator ID="RangeValidator2" runat ="server" ControlToValidate="txtPrice5" 

                    Display="Dynamic" ErrorMessage="The value must be from 10001 to 50000!""  

                    Font-Size="X-Small" MaximumValue="100000" MinimumValue="50001" 

                    EnableClientScript="False" Type="Integer">
            </td>
            <td class="style7">
                 </td>
            <td class="style7">
                <asp:Label ID="Label10" runat="server" Font-Bold="True" Text="Stock">
            </td>
            <td>
                <asp:TextBox ID="txtStock" runat="server" CssClass="inputtxt">
                <asp:FilteredTextBoxExtender ID="txtStock_FilteredTextBoxExtender" 

                    runat="server" Enabled="True" TargetControlID="txtStock" 

                    FilterType="Numbers" >
                
                
            </td>
        </tr>
        <tr>
            <td class="style5">
                 </td>
            <td class="style6">
                 </td>
            <td class="style7">
                 </td>
            <td class="style7">
                 </td>
            <td><asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat ="server" 

                    ControlToValidate="txtStock" Display="Dynamic" 

                    ErrorMessage="Please Enter Stock" 

                    Font-Size="X-Small">
                 </td>
        </tr>
        <tr>
        <td>
            <asp:Label ID="lblTAX" runat="server" Font-Bold="True" Text="TAX%">
            </td><td>
                <asp:TextBox ID="txttax" runat="server" CssClass="inputtxt">
            </td><td></td><td>
            <asp:Label ID="lblfreightcharges" runat="server" Text="Freight Charges" 

                Font-Bold ="True">
            </td><td>
                <asp:TextBox ID="txtFreightCharges" runat="server" CssClass="inputtxt">
           </td> 
        
            </tr>
        <tr>
            <td>
                 </td>
            <td>
                 </td>
            <td>
                 </td>
            <td>
                 </td>
            <td><asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat ="server" 

                    ControlToValidate="txtFreightCharges" Display="Dynamic" 

                    ErrorMessage="Please Enter Frieght Charges" 

                    Font-Size="X-Small">
                 </td>
            <td>
                 </td>
        </tr>
    </table>
    </contenttemplate>
    
    
    <asp:Button ID="btnSave" runat="server" Text="Save" CssClass="button" 

        Font-Bold="True" Height="40px" onclick="Save_Click" />
    <asp:Button ID="btnUpdate" runat="server" CssClass="button" Font-Bold="True" 

        Height="40px" onclick="btnUpdate_Click" Text="Update" />
 </form> 
 </div>  
</body>
</html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;




public partial class AddItemDetails : System.Web.UI.Page
{
    // con is used for sqlConnection it get the Connection from connectionString class
    static SqlConnection con = new SqlConnection(IMS.ConnectionString.getValue());
    //da is used for fill dataSets
    SqlDataAdapter da;
    //ds is used Store Data 
    DataSet ds;
    static  int i;
    static string SupId,MakeId;
 



    protected void Page_Load(object sender, EventArgs e)
    {
        //This If condition Is Used To Check the Session avilabilty is Session is Not There Is Redirect to the LoginPage
       
        
       sessions.getsessions();
       //btnUpdate.Visible = false;
       // For query to fetch Data from Database
        string que;
        //If Page is first time Loading it Exeecute This If block
        da = new SqlDataAdapter("select max(sno) from Item ", con);
        ds = new DataSet();
        da.Fill(ds, "id");
        i = int.Parse(ds.Tables["id"].Rows[0][0].ToString());
        if (!IsPostBack)
        {
            // c is cookie with Name_Auth
       HttpCookie c = Request.Cookies["_Auth"];
        if (Request.QueryString["U"] == "ITM")
            {
              
               if (Session["UTI"].ToString() == "UT107")
                {
                    que = "select IP.Item_Id ,IP.Item_Make_Id,IP.Item_Supplier_Id ,IP.Item_Price1,IP.Item_Price2,IP.Item_Price3,IP.Item_Price4,IP.Item_Price5,IP.Item_Stock,I.Item_Description,I.Item_type_Id,IP.[TAX%],IP.freight from item i,Item_priceAndVendor ip where IP.Item_Id=I.Item_Id and Item_Supplier_Id=''" + Session["UI"].ToString() + "'' and Ip.Item_Supplier_Id=''" + IMSNiana.SupplierId + "'' and ip.Item_Id=''" + IMSNiana.ItemId + "'' and IP.Item_Make_Id=''" + IMSNiana.MakeId + "''";
                }
                else
                {
                    que = "select IP.Item_Id ,IP.Item_Make_Id,IP.Item_Supplier_Id ,IP.Item_Price1,IP.Item_Price2,IP.Item_Price3,IP.Item_Price4,IP.Item_Price5,IP.Item_Stock,I.Item_Description,I.Item_type_Id,IP.[TAX%],IP.freight from item i,Item_priceAndVendor ip where IP.Item_Id=I.Item_Id  and Ip.Item_Supplier_Id=''" + IMSNiana.SupplierId + "'' and Ip.Item_Id=''" + IMSNiana.ItemId + "'' and IP.Item_Make_Id=''" + IMSNiana.MakeId + "''";
                }
                da = new SqlDataAdapter(que, con);
                ds = new DataSet();
                da.Fill(ds, "Itemdetails");
                txtItemDescription.Text = IMSNiana.ItemDescription;
                txtMake.Text = IMSNiana.MakeName;
                txtSupplier.Text = IMSNiana.SupplierName;
                txtStock.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Stock"].ToString();
                txtPrice1.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price1"].ToString();
                txtprice2.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price2"].ToString();
                txtPrice3.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price3"].ToString();
                txtprice4.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price4"].ToString();
                txtprice5.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price5"].ToString();
                txtFreightCharges.Text = ds.Tables["Itemdetails"].Rows[0]["freight"].ToString();
                txttax.Text = ds.Tables["Itemdetails"].Rows[0]["TAX%"].ToString();
                ddlItemType.SelectedValue = ds.Tables["Itemdetails"].Rows[0]["Item_type_Id"].ToString();
                txtItemDescription.Enabled = txtMake.Enabled = txtSupplier.Enabled = ddlItemType.Enabled = false;
                btnSave.Visible = false;
                btnUpdate.Visible = true;
                lblPage.Text = "Edit Item Details";
            }
          
          }
        try
        {
            if (txtSupplier.Text != "")
            {
                string query = "select User_Id from UserTable where User_Name=''" + txtSupplier.Text + "'' and User_type_id=''UT107''";
                SqlDataAdapter daSup = new SqlDataAdapter(query, con);
                DataSet dsSup = new DataSet();
                daSup.Fill(dsSup, "Supplier");
                SupId = dsSup.Tables["Supplier"].Rows[0][0].ToString();
            }
            else
            {
            }
            if (txtMake.Text != "")
            {
                string query = "select make_id from Make where make_Name=''" + txtMake.Text + "''";
                SqlDataAdapter daMake = new SqlDataAdapter(query, con);
                DataSet dsMake = new DataSet();
                daMake.Fill(dsMake, "MakeId");
                MakeId = dsMake.Tables["MakeId"].Rows[0][0].ToString();
            }
            else
            {
            }
        }
        catch
        {
        }
    }
 

    
    protected void Save_Click(object sender, EventArgs e)
    {
          da = new SqlDataAdapter("select max(sno) from Item ", con);
            ds = new DataSet();
            da.Fill(ds, "id");
            i =int.Parse(ds.Tables["id"].Rows[0][0].ToString());
        string Itemid = "ITM" + i;
        string  Icreatedby;       
        string IcreatedDate;
       // HttpCookie c = Request.Cookies["_Auth"];
        Icreatedby = Session["UN"].ToString(); 
            //c.Values["UN"];
        //t1 = (TextBox)r.FindControl("txtItemcreatedDate");
        IcreatedDate = DateTime.Now.ToShortDateString();
        SqlDataAdapter das = new SqlDataAdapter("select Item_Id from Item where Item_Description like''" +txtItemDescription.Text + "''", con);
        DataSet dss = new DataSet();
        das.Fill(dss, "item");
        //if (dss.Tables["item"].Rows.Count == 0 && c.Values["UTI"]!="UT107")
        if (dss.Tables["item"].Rows.Count == 0 && Session["UTI"].ToString()!= "UT107")
        {
            //SqlDataAdapter dat = new SqlDataAdapter("insert into item values(''" + Itemid + "'',''" + txtItemDescription.Text+ "'',''" +ddlItemType.SelectedItem.Value+ "'')", con);
            SqlDataAdapter dat = new SqlDataAdapter("insert into item(Item_Id,Item_Description,Item_type_Id(''" + Itemid + "'',''" + txtItemDescription.Text + "'',''" + ddlItemType.SelectedItem.Value + "'')", con);     //by shruthi
            DataSet dsi = new DataSet();
            dat.Fill(dsi, "Item");
            //string s = "insert into Item_priceAndVendor (Item_Id, Item_Make_Id,Item_Supplier_Id,Item_Price1,Item_Price2,Item_Price3,Item_Price4,Item_Price5,Item_Stock,Item_createdby,Item_createdDate)values(''" + Itemid + "'',''" + MakeId + "'',''" + SupId + "''," + txtPrice1.Text + "," + txtprice2.Text + "," + txtPrice3.Text + "," + txtprice4.Text + "," + txtprice5.Text + "," + txtStock.Text + ",''" + Icreatedby + "'',''" + IcreatedDate + "'')";
            // da = new SqlDataAdapter(s, con);
            //ds = new DataSet();
            //da.Fill(ds, "ItemDetails");          
        }
        else if (dss.Tables["item"].Rows.Count == 0 &&  Session["UTI"].ToString()=="UT107")//c.Values["UTI"] == "UT107")
        {
            //Page.ClientScript.RegisterStartupScript(GetType(), "f3", "alert(''This Item Not Present'')", true);
        }
        else
        {
            Itemid = dss.Tables["item"].Rows[0][0].ToString();
            string s = "insert into Item_priceAndVendor (Item_Id, Item_Make_Id,Item_Supplier_Id,Item_Price1,Item_Price2,Item_Price3,Item_Price4,Item_Price5,Item_Stock,Item_createdby,Item_createdDate,[TAX%],freight)values(''" + Itemid + "'',''" + MakeId + "'',''" + SupId + "''," + txtPrice1.Text + "," + txtprice2.Text + "," + txtPrice3.Text + "," + txtprice4.Text + "," + txtprice5.Text + "," + txtStock.Text + ",''" + Icreatedby + "'',''" + IcreatedDate + "'',"+txttax.Text+","+txtFreightCharges.Text+")";
             da = new SqlDataAdapter(s, con);
            ds = new DataSet();
            da.Fill(ds, "ItemDetails");
        }    
    }
    
Protected void btnUpdate_Click(object sender, EventArgs e)
    {
        if (txtFreightCharges.Text != "" && txttax.Text != "" && txtprice4.Text != "" && txtprice5.Text != "" && txtPrice3.Text != "" && txtprice2.Text != "" && txtPrice1.Text != "" && txtStock.Text != "")
        {
            SqlDataAdapter das = new SqlDataAdapter("select Item_Id from Item where Item_Description like''" + txtItemDescription.Text + "''", con);
            DataSet dss = new DataSet();
            das.Fill(dss, "item");
            string ItId = dss.Tables["item"].Rows[0][0].ToString();
            string s = "update Item_priceAndVendor  set Item_Price1=" + txtPrice1.Text + ",Item_Price2=" + txtprice2.Text + ",Item_Price3=" + txtPrice3.Text + ",Item_Price4=" + txtprice4.Text + ",Item_Price5=" + txtprice5.Text + ",Item_Stock=" + txtStock.Text + ",[TAX%]=" + txttax.Text + ",freight=" + txtFreightCharges.Text + " where Item_Make_Id=''" + MakeId + "'' and Item_Supplier_Id=''" + SupId + "'' and Item_Id=''" + ItId + "''";
            SqlDataAdapter da = new SqlDataAdapter(s, con);
            ds = new DataSet();
            da.Fill(ds, "ItemDetails");
            //tbPanel.Visible = false;
            //btnUpdate.Visible = false;
            Page.ClientScript.RegisterStartupScript(GetType(), "K1", "parent.location.reload(true);", true);
        }
    }
}

推荐答案

ConnectionStrings:IMS %>" SelectCommand =" < /td > < td =" style7" < /td > < td =" style7" <asp:Label ID="lblMake" runat="server" Font-Bold="True" Text="Make"> < /td > < td > <asp:TextBox ID="txtMake" runat="server" CssClass="inputtxt" Height="32px"> < asp:AutoCompleteExtender ID =" runat 服务器" =" =" 100" DelimiterCharacters =" =" 真实" ServicePath 〜/AutoComplte.asmx" ServiceMethod 制作" TargetControlID =" > < /td > < /tr > < tr > < td =" style5" < /td > < td =" style6" < /td > < td =" style7" < /td > < td =" style7" < /td > <td><asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat ="server" span> ControlToValidate =" =" Dynamic" ErrorMessage="Please Enter Make" Font-Size="X-Small"> < /td > < /tr > < tr > < td =" style5" <asp:Label ID="ldlItemDescription" runat="server" Font-Bold="True" Text="Item Description"> < /td > < td =" style6" <asp:TextBox ID="txtItemDescription" runat="server" Height="45px" span> TextMode =" =" 142px" CssClass="inputtxt"> <asp:AutoCompleteExtender ID="txtItemDescription_AutoCompleteExtender" span> runat =" =" " 已启用 True" ServicePath =" CompletionInterval =" MinimumPrefixLength =" ServiceMethod =" span> TargetControlID =" > < /td > < td =" style7" < /td > < td =" style7" <asp:Label ID="lblSupplier" runat="server" Font-Bold="True" Text="Supplier"> < /td > < td > <asp:TextBox ID="txtSupplier" runat="server" Height="42px" TextMode="MultiLine" 宽度 =" =" inputtxt"> <asp:AutoCompleteExtender ID="txtSupplier_AutoCompleteExtender" runat="server" DelimiterCharacters =" =" True" ServicePath="~/AutoComplte.asmx" CompletionInterval="100" MinimumPrefixLength="0" ServiceMethod="suppliername" TargetControlID="txtSupplier"> < /td > < /tr > < tr > < td =" style5" <asp:Label ID="LblPrice1" runat="server" Font-Bold="True" Text="Price(1-100)" Width="100px"> < /td > < td =" style6" <asp:TextBox ID="txtPrice1" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtPrice1_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtPrice1" ValidChars="." FilterType="Custom, Numbers"> <asp:RequiredFieldValidator ID="range1" runat ="server" ControlToValidate="txtPrice1" Display="Dynamic" ErrorMessage="Please Enter value (1-100)" Font-Size="X-Small"> <asp:RangeValidator ID="rnge1" runat ="server" ControlToValidate="txtPrice1" Display="Dynamic" ErrorMessage="The value must be from 1 to 100!"" Font-Size="X-Small" MaximumValue="100" MinimumValue="1" EnableClientScript="False" Type="Integer"> < /td > < td =" style7" < /td > < td =" style7" <asp:Label ID="Label8" runat="server" Font-Bold="True" Text="price(101-1000)" Width="150px"> < /td > < td > <asp:TextBox ID="txtprice2" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtprice2_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtprice2" ValidChars="." FilterType="Custom, Numbers"> < /td > < /tr > < tr > < td =" style5" < /td > < td =" style6" < /td > < td =" style7" < /td > < td =" style7" < /td > <td><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat ="server" ControlToValidate="txtprice2" Display="Dynamic" ErrorMessage="Please Enter value (101-1000)" Font-Size="X-Small"> <asp:RangeValidator ID="RangeValidator3" runat ="server" ControlToValidate="txtPrice2" Display="Dynamic" ErrorMessage="The value must be from 101 to 1000!"" Font-Size="X-Small" MaximumValue="1000" MinimumValue="101" EnableClientScript="False" Type="Integer"> < /td > < /tr > < tr > < td =" style5" <asp:Label ID="Label4" runat="server" Font-Bold="True" Text="price(1001-10000)" Width="160px"> < /td > < td =" style6" <asp:TextBox ID="txtPrice3" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtPrice3_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtPrice3" ValidChars="." FilterType="Custom, Numbers"> <asp:RequiredFieldValidator ID="Reqp3" runat ="server" ControlToValidate="txtprice3" Display="Dynamic" ErrorMessage="Please Enter value (1001-10000)" Font-Size="X-Small"> <asp:RangeValidator ID="Rangp3" runat ="server" ControlToValidate="txtPrice3" Display="Dynamic" ErrorMessage="The value must be from 101 to 1000!"" Font-Size="X-Small" MaximumValue="10000" MinimumValue="1001" EnableClientScript="False" Type="Integer"> < /td > < td =" style7" < /td > < td =" style7" <asp:Label ID="Label9" runat="server" Font-Bold="True" Text="Price(10001-50000)" Width="170px"> < /td > < td > <asp:TextBox ID="txtprice4" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtprice4_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtprice4" ValidChars="." FilterType="Custom, Numbers"> < /td > < /tr > < tr > < td =" style5" < /td > < td =" style6" < /td > < td =" style7" < /td > < td =" style7" < /td > <td><asp:RequiredFieldValidator ID="Reqp4" runat ="server" ControlToValidate="txtprice4" Display="Dynamic" ErrorMessage="Please Enter value (10001-50000)" Font-Size="X-Small"> <asp:RangeValidator ID="RangeValidator1" runat ="server" ControlToValidate="txtPrice4" Display="Dynamic" ErrorMessage="The value must be from 10001 to 50000!"" Font-Size="X-Small" MaximumValue="50000" MinimumValue="10001" EnableClientScript="False" Type="Integer"> < /td > < /tr > < tr > < td =" style5" <asp:Label ID="Label5" runat="server" Font-Bold="True" Text="Price(50001-100000)" Width="170px"> < /td > < td =" style6" <asp:TextBox ID="txtprice5" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtprice5_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtprice5" ValidChars="." FilterType="Custom, Numbers"> <asp:RequiredFieldValidator ID="Reqp5" runat ="server" ControlToValidate="txtprice5" Display="Dynamic" ErrorMessage="Please Enter value (50001-100000)" Font-Size="X-Small"> <asp:RangeValidator ID="RangeValidator2" runat ="server" ControlToValidate="txtPrice5" Display="Dynamic" ErrorMessage="The value must be from 10001 to 50000!"" Font-Size="X-Small" MaximumValue="100000" MinimumValue="50001" EnableClientScript="False" Type="Integer"> < /td > < td =" style7" < /td > < td =" style7" <asp:Label ID="Label10" runat="server" Font-Bold="True" Text="Stock"> < /td > < td > <asp:TextBox ID="txtStock" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtStock_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtStock" FilterType="Numbers" > < /td > < /tr > < tr > < td =" style5" < /td > < td =" style6" < /td > < td =" style7" < /td > < td =" style7" < /td > <td><asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat ="server" ControlToValidate="txtStock" Display="Dynamic" ErrorMessage="Please Enter Stock" Font-Size="X-Small"> < /td > < /tr > < tr > < td > <asp:Label ID="lblTAX" runat="server" Font-Bold="True" Text="TAX%"> </td><td> <asp:TextBox ID="txttax" runat="server" CssClass="inputtxt"> </td><td></td><td> <asp:Label ID="lblfreightcharges" runat="server" Text="Freight Charges" Font-Bold ="True"> </td><td> <asp:TextBox ID="txtFreightCharges" runat="server" CssClass="inputtxt"> < /td > < /tr > < tr > < td > < /td > < td > < /td > < td > < /td > < td > < /td > <td><asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat ="server" ControlToValidate="txtFreightCharges" Display="Dynamic" ErrorMessage="Please Enter Frieght Charges" Font-Size="X-Small"> < /td > < td > < /td > < /tr > < /table > < /contenttemplate > <asp:Button ID="btnSave" runat="server" Text="Save" CssClass="button" Font-Bold="True" Height="40px" onclick="Save_Click" /> <asp:Button ID="btnUpdate" runat="server" CssClass="button" Font-Bold="True" Height="40px" onclick="btnUpdate_Click" Text="Update" /> < /form > < /div > < /body > < /html >

ConnectionStrings:IMS %>" SelectCommand="SELECT [Item_Type_Id], [Item_Type_Name] FROM [ItemType]"> </td> <td class="style7"> </td> <td class="style7"> <asp:Label ID="lblMake" runat="server" Font-Bold="True" Text="Make"> </td> <td> <asp:TextBox ID="txtMake" runat="server" CssClass="inputtxt" Height="32px"> <asp:AutoCompleteExtender ID="txtMake_AutoCompleteExtender" runat="server" MinimumPrefixLength="0" CompletionInterval="100" DelimiterCharacters="" Enabled="True" ServicePath="~/AutoComplte.asmx" ServiceMethod="Make" TargetControlID="txtMake"> </td> </tr> <tr> <td class="style5"> </td> <td class="style6"> </td> <td class="style7"> </td> <td class="style7"> </td> <td><asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat ="server" ControlToValidate="txtMake" Display="Dynamic" ErrorMessage="Please Enter Make" Font-Size="X-Small"> </td> </tr> <tr> <td class="style5"> <asp:Label ID="ldlItemDescription" runat="server" Font-Bold="True" Text="Item Description"> </td> <td class="style6"> <asp:TextBox ID="txtItemDescription" runat="server" Height="45px" TextMode="MultiLine" Width="142px" CssClass="inputtxt"> <asp:AutoCompleteExtender ID="txtItemDescription_AutoCompleteExtender" runat="server" DelimiterCharacters="" Enabled="True" ServicePath="~/AutoComplte.asmx" CompletionInterval="100" MinimumPrefixLength="0" ServiceMethod="GetCompletionList" TargetControlID="txtItemDescription"> </td> <td class="style7"> </td> <td class="style7"> <asp:Label ID="lblSupplier" runat="server" Font-Bold="True" Text="Supplier"> </td> <td> <asp:TextBox ID="txtSupplier" runat="server" Height="42px" TextMode="MultiLine" Width="134px" CssClass="inputtxt"> <asp:AutoCompleteExtender ID="txtSupplier_AutoCompleteExtender" runat="server" DelimiterCharacters="" Enabled="True" ServicePath="~/AutoComplte.asmx" CompletionInterval="100" MinimumPrefixLength="0" ServiceMethod="suppliername" TargetControlID="txtSupplier"> </td> </tr> <tr> <td class="style5"> <asp:Label ID="LblPrice1" runat="server" Font-Bold="True" Text="Price(1-100)" Width="100px"> </td> <td class="style6"> <asp:TextBox ID="txtPrice1" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtPrice1_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtPrice1" ValidChars="." FilterType="Custom, Numbers"> <asp:RequiredFieldValidator ID="range1" runat ="server" ControlToValidate="txtPrice1" Display="Dynamic" ErrorMessage="Please Enter value (1-100)" Font-Size="X-Small"> <asp:RangeValidator ID="rnge1" runat ="server" ControlToValidate="txtPrice1" Display="Dynamic" ErrorMessage="The value must be from 1 to 100!"" Font-Size="X-Small" MaximumValue="100" MinimumValue="1" EnableClientScript="False" Type="Integer"> </td> <td class="style7"> </td> <td class="style7"> <asp:Label ID="Label8" runat="server" Font-Bold="True" Text="price(101-1000)" Width="150px"> </td> <td> <asp:TextBox ID="txtprice2" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtprice2_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtprice2" ValidChars="." FilterType="Custom, Numbers"> </td> </tr> <tr> <td class="style5"> </td> <td class="style6"> </td> <td class="style7"> </td> <td class="style7"> </td> <td><asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat ="server" ControlToValidate="txtprice2" Display="Dynamic" ErrorMessage="Please Enter value (101-1000)" Font-Size="X-Small"> <asp:RangeValidator ID="RangeValidator3" runat ="server" ControlToValidate="txtPrice2" Display="Dynamic" ErrorMessage="The value must be from 101 to 1000!"" Font-Size="X-Small" MaximumValue="1000" MinimumValue="101" EnableClientScript="False" Type="Integer"> </td> </tr> <tr> <td class="style5"> <asp:Label ID="Label4" runat="server" Font-Bold="True" Text="price(1001-10000)" Width="160px"> </td> <td class="style6"> <asp:TextBox ID="txtPrice3" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtPrice3_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtPrice3" ValidChars="." FilterType="Custom, Numbers"> <asp:RequiredFieldValidator ID="Reqp3" runat ="server" ControlToValidate="txtprice3" Display="Dynamic" ErrorMessage="Please Enter value (1001-10000)" Font-Size="X-Small"> <asp:RangeValidator ID="Rangp3" runat ="server" ControlToValidate="txtPrice3" Display="Dynamic" ErrorMessage="The value must be from 101 to 1000!"" Font-Size="X-Small" MaximumValue="10000" MinimumValue="1001" EnableClientScript="False" Type="Integer"> </td> <td class="style7"> </td> <td class="style7"> <asp:Label ID="Label9" runat="server" Font-Bold="True" Text="Price(10001-50000)" Width="170px"> </td> <td> <asp:TextBox ID="txtprice4" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtprice4_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtprice4" ValidChars="." FilterType="Custom, Numbers"> </td> </tr> <tr> <td class="style5"> </td> <td class="style6"> </td> <td class="style7"> </td> <td class="style7"> </td> <td><asp:RequiredFieldValidator ID="Reqp4" runat ="server" ControlToValidate="txtprice4" Display="Dynamic" ErrorMessage="Please Enter value (10001-50000)" Font-Size="X-Small"> <asp:RangeValidator ID="RangeValidator1" runat ="server" ControlToValidate="txtPrice4" Display="Dynamic" ErrorMessage="The value must be from 10001 to 50000!"" Font-Size="X-Small" MaximumValue="50000" MinimumValue="10001" EnableClientScript="False" Type="Integer"> </td> </tr> <tr> <td class="style5"> <asp:Label ID="Label5" runat="server" Font-Bold="True" Text="Price(50001-100000)" Width="170px"> </td> <td class="style6"> <asp:TextBox ID="txtprice5" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtprice5_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtprice5" ValidChars="." FilterType="Custom, Numbers"> <asp:RequiredFieldValidator ID="Reqp5" runat ="server" ControlToValidate="txtprice5" Display="Dynamic" ErrorMessage="Please Enter value (50001-100000)" Font-Size="X-Small"> <asp:RangeValidator ID="RangeValidator2" runat ="server" ControlToValidate="txtPrice5" Display="Dynamic" ErrorMessage="The value must be from 10001 to 50000!"" Font-Size="X-Small" MaximumValue="100000" MinimumValue="50001" EnableClientScript="False" Type="Integer"> </td> <td class="style7"> </td> <td class="style7"> <asp:Label ID="Label10" runat="server" Font-Bold="True" Text="Stock"> </td> <td> <asp:TextBox ID="txtStock" runat="server" CssClass="inputtxt"> <asp:FilteredTextBoxExtender ID="txtStock_FilteredTextBoxExtender" runat="server" Enabled="True" TargetControlID="txtStock" FilterType="Numbers" > </td> </tr> <tr> <td class="style5"> </td> <td class="style6"> </td> <td class="style7"> </td> <td class="style7"> </td> <td><asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat ="server" ControlToValidate="txtStock" Display="Dynamic" ErrorMessage="Please Enter Stock" Font-Size="X-Small"> </td> </tr> <tr> <td> <asp:Label ID="lblTAX" runat="server" Font-Bold="True" Text="TAX%"> </td><td> <asp:TextBox ID="txttax" runat="server" CssClass="inputtxt"> </td><td></td><td> <asp:Label ID="lblfreightcharges" runat="server" Text="Freight Charges" Font-Bold ="True"> </td><td> <asp:TextBox ID="txtFreightCharges" runat="server" CssClass="inputtxt"> </td> </tr> <tr> <td> </td> <td> </td> <td> </td> <td> </td> <td><asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat ="server" ControlToValidate="txtFreightCharges" Display="Dynamic" ErrorMessage="Please Enter Frieght Charges" Font-Size="X-Small"> </td> <td> </td> </tr> </table> </contenttemplate> <asp:Button ID="btnSave" runat="server" Text="Save" CssClass="button" Font-Bold="True" Height="40px" onclick="Save_Click" /> <asp:Button ID="btnUpdate" runat="server" CssClass="button" Font-Bold="True" Height="40px" onclick="btnUpdate_Click" Text="Update" /> </form> </div> </body> </html>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;




public partial class AddItemDetails : System.Web.UI.Page
{
    // con is used for sqlConnection it get the Connection from connectionString class
    static SqlConnection con = new SqlConnection(IMS.ConnectionString.getValue());
    //da is used for fill dataSets
    SqlDataAdapter da;
    //ds is used Store Data 
    DataSet ds;
    static  int i;
    static string SupId,MakeId;
 



    protected void Page_Load(object sender, EventArgs e)
    {
        //This If condition Is Used To Check the Session avilabilty is Session is Not There Is Redirect to the LoginPage
       
        
       sessions.getsessions();
       //btnUpdate.Visible = false;
       // For query to fetch Data from Database
        string que;
        //If Page is first time Loading it Exeecute This If block
        da = new SqlDataAdapter("select max(sno) from Item ", con);
        ds = new DataSet();
        da.Fill(ds, "id");
        i = int.Parse(ds.Tables["id"].Rows[0][0].ToString());
        if (!IsPostBack)
        {
            // c is cookie with Name_Auth
       HttpCookie c = Request.Cookies["_Auth"];
        if (Request.QueryString["U"] == "ITM")
            {
              
               if (Session["UTI"].ToString() == "UT107")
                {
                    que = "select IP.Item_Id ,IP.Item_Make_Id,IP.Item_Supplier_Id ,IP.Item_Price1,IP.Item_Price2,IP.Item_Price3,IP.Item_Price4,IP.Item_Price5,IP.Item_Stock,I.Item_Description,I.Item_type_Id,IP.[TAX%],IP.freight from item i,Item_priceAndVendor ip where IP.Item_Id=I.Item_Id and Item_Supplier_Id=''" + Session["UI"].ToString() + "'' and Ip.Item_Supplier_Id=''" + IMSNiana.SupplierId + "'' and ip.Item_Id=''" + IMSNiana.ItemId + "'' and IP.Item_Make_Id=''" + IMSNiana.MakeId + "''";
                }
                else
                {
                    que = "select IP.Item_Id ,IP.Item_Make_Id,IP.Item_Supplier_Id ,IP.Item_Price1,IP.Item_Price2,IP.Item_Price3,IP.Item_Price4,IP.Item_Price5,IP.Item_Stock,I.Item_Description,I.Item_type_Id,IP.[TAX%],IP.freight from item i,Item_priceAndVendor ip where IP.Item_Id=I.Item_Id  and Ip.Item_Supplier_Id=''" + IMSNiana.SupplierId + "'' and Ip.Item_Id=''" + IMSNiana.ItemId + "'' and IP.Item_Make_Id=''" + IMSNiana.MakeId + "''";
                }
                da = new SqlDataAdapter(que, con);
                ds = new DataSet();
                da.Fill(ds, "Itemdetails");
                txtItemDescription.Text = IMSNiana.ItemDescription;
                txtMake.Text = IMSNiana.MakeName;
                txtSupplier.Text = IMSNiana.SupplierName;
                txtStock.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Stock"].ToString();
                txtPrice1.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price1"].ToString();
                txtprice2.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price2"].ToString();
                txtPrice3.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price3"].ToString();
                txtprice4.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price4"].ToString();
                txtprice5.Text = ds.Tables["Itemdetails"].Rows[0]["Item_Price5"].ToString();
                txtFreightCharges.Text = ds.Tables["Itemdetails"].Rows[0]["freight"].ToString();
                txttax.Text = ds.Tables["Itemdetails"].Rows[0]["TAX%"].ToString();
                ddlItemType.SelectedValue = ds.Tables["Itemdetails"].Rows[0]["Item_type_Id"].ToString();
                txtItemDescription.Enabled = txtMake.Enabled = txtSupplier.Enabled = ddlItemType.Enabled = false;
                btnSave.Visible = false;
                btnUpdate.Visible = true;
                lblPage.Text = "Edit Item Details";
            }
          
          }
        try
        {
            if (txtSupplier.Text != "")
            {
                string query = "select User_Id from UserTable where User_Name=''" + txtSupplier.Text + "'' and User_type_id=''UT107''";
                SqlDataAdapter daSup = new SqlDataAdapter(query, con);
                DataSet dsSup = new DataSet();
                daSup.Fill(dsSup, "Supplier");
                SupId = dsSup.Tables["Supplier"].Rows[0][0].ToString();
            }
            else
            {
            }
            if (txtMake.Text != "")
            {
                string query = "select make_id from Make where make_Name=''" + txtMake.Text + "''";
                SqlDataAdapter daMake = new SqlDataAdapter(query, con);
                DataSet dsMake = new DataSet();
                daMake.Fill(dsMake, "MakeId");
                MakeId = dsMake.Tables["MakeId"].Rows[0][0].ToString();
            }
            else
            {
            }
        }
        catch
        {
        }
    }
 

    
    protected void Save_Click(object sender, EventArgs e)
    {
          da = new SqlDataAdapter("select max(sno) from Item ", con);
            ds = new DataSet();
            da.Fill(ds, "id");
            i =int.Parse(ds.Tables["id"].Rows[0][0].ToString());
        string Itemid = "ITM" + i;
        string  Icreatedby;       
        string IcreatedDate;
       // HttpCookie c = Request.Cookies["_Auth"];
        Icreatedby = Session["UN"].ToString(); 
            //c.Values["UN"];
        //t1 = (TextBox)r.FindControl("txtItemcreatedDate");
        IcreatedDate = DateTime.Now.ToShortDateString();
        SqlDataAdapter das = new SqlDataAdapter("select Item_Id from Item where Item_Description like''" +txtItemDescription.Text + "''", con);
        DataSet dss = new DataSet();
        das.Fill(dss, "item");
        //if (dss.Tables["item"].Rows.Count == 0 && c.Values["UTI"]!="UT107")
        if (dss.Tables["item"].Rows.Count == 0 && Session["UTI"].ToString()!= "UT107")
        {
            //SqlDataAdapter dat = new SqlDataAdapter("insert into item values(''" + Itemid + "'',''" + txtItemDescription.Text+ "'',''" +ddlItemType.SelectedItem.Value+ "'')", con);
            SqlDataAdapter dat = new SqlDataAdapter("insert into item(Item_Id,Item_Description,Item_type_Id(''" + Itemid + "'',''" + txtItemDescription.Text + "'',''" + ddlItemType.SelectedItem.Value + "'')", con);     //by shruthi
            DataSet dsi = new DataSet();
            dat.Fill(dsi, "Item");
            //string s = "insert into Item_priceAndVendor (Item_Id, Item_Make_Id,Item_Supplier_Id,Item_Price1,Item_Price2,Item_Price3,Item_Price4,Item_Price5,Item_Stock,Item_createdby,Item_createdDate)values(''" + Itemid + "'',''" + MakeId + "'',''" + SupId + "''," + txtPrice1.Text + "," + txtprice2.Text + "," + txtPrice3.Text + "," + txtprice4.Text + "," + txtprice5.Text + "," + txtStock.Text + ",''" + Icreatedby + "'',''" + IcreatedDate + "'')";
            // da = new SqlDataAdapter(s, con);
            //ds = new DataSet();
            //da.Fill(ds, "ItemDetails");          
        }
        else if (dss.Tables["item"].Rows.Count == 0 &&  Session["UTI"].ToString()=="UT107")//c.Values["UTI"] == "UT107")
        {
            //Page.ClientScript.RegisterStartupScript(GetType(), "f3", "alert(''This Item Not Present'')", true);
        }
        else
        {
            Itemid = dss.Tables["item"].Rows[0][0].ToString();
            string s = "insert into Item_priceAndVendor (Item_Id, Item_Make_Id,Item_Supplier_Id,Item_Price1,Item_Price2,Item_Price3,Item_Price4,Item_Price5,Item_Stock,Item_createdby,Item_createdDate,[TAX%],freight)values(''" + Itemid + "'',''" + MakeId + "'',''" + SupId + "''," + txtPrice1.Text + "," + txtprice2.Text + "," + txtPrice3.Text + "," + txtprice4.Text + "," + txtprice5.Text + "," + txtStock.Text + ",''" + Icreatedby + "'',''" + IcreatedDate + "'',"+txttax.Text+","+txtFreightCharges.Text+")";
             da = new SqlDataAdapter(s, con);
            ds = new DataSet();
            da.Fill(ds, "ItemDetails");
        }    
    }
    
Protected void btnUpdate_Click(object sender, EventArgs e)
    {
        if (txtFreightCharges.Text != "" && txttax.Text != "" && txtprice4.Text != "" && txtprice5.Text != "" && txtPrice3.Text != "" && txtprice2.Text != "" && txtPrice1.Text != "" && txtStock.Text != "")
        {
            SqlDataAdapter das = new SqlDataAdapter("select Item_Id from Item where Item_Description like''" + txtItemDescription.Text + "''", con);
            DataSet dss = new DataSet();
            das.Fill(dss, "item");
            string ItId = dss.Tables["item"].Rows[0][0].ToString();
            string s = "update Item_priceAndVendor  set Item_Price1=" + txtPrice1.Text + ",Item_Price2=" + txtprice2.Text + ",Item_Price3=" + txtPrice3.Text + ",Item_Price4=" + txtprice4.Text + ",Item_Price5=" + txtprice5.Text + ",Item_Stock=" + txtStock.Text + ",[TAX%]=" + txttax.Text + ",freight=" + txtFreightCharges.Text + " where Item_Make_Id=''" + MakeId + "'' and Item_Supplier_Id=''" + SupId + "'' and Item_Id=''" + ItId + "''";
            SqlDataAdapter da = new SqlDataAdapter(s, con);
            ds = new DataSet();
            da.Fill(ds, "ItemDetails");
            //tbPanel.Visible = false;
            //btnUpdate.Visible = false;
            Page.ClientScript.RegisterStartupScript(GetType(), "K1", "parent.location.reload(true);", true);
        }
    }
}

这篇关于在ASP.NET中添加含税的itemdetails的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文

在ASP.NET中添加含税的itemdetails [英] Add itemdetails with tax in ASP.NET

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

在ASP.NET中添加含税的itemdetails [英] Add itemdetails with tax in ASP.NET

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭