System/Sys_JWage_Add.aspx.cs

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

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

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.OleDb;

public partial class System_Sys_Lgr_List : System.Web.UI.Page
{
    public string X_Month = "";//月份
    public string X_Manager_User = ""; //教师帐号
    public int X_Total = 0;//课时
    public int X_BC = 0;//课时补差
    public decimal X_XS = 0;//系数
    public decimal X_Price = 0;//单价
    public decimal X_Subsidy = 0;//补贴
    public decimal X_Othor = 0;//其他
    public decimal X_Money_Total = 0;//总工资

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Get_Data();

        }
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        Get_Data();
        DB.ExecuteSql("insert into X_Wage(X_Month,X_Manager_User,X_Total,X_BC,X_XS,X_Price,X_Subsidy,X_Othor,X_Money_Total)values('" + X_Month + "','" + X_Manager_User + "'," + X_Total + "," + X_BC + ",1," + X_Price + "," + X_Subsidy + "," + X_Othor + "," + X_Money_Total + ")");
        Common.ShowMessage(Page,"提交成功！","");
    }

    void Get_Data()
    {
        OleDbConnection cn = DB.OpenConnection();
        try
        {
            OleDbCommand cmd = new OleDbCommand("select * from [X_Lesson] where X_Month='"+DropDownList1.SelectedValue+"'" , cn);
            OleDbDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                this.Button3.Enabled = true;
                this.lb_.Text = "";

                X_Month = DropDownList1.SelectedValue;
                X_Manager_User = HttpUtility.UrlDecode(Request.Cookies["xzfpp"]["Manager"].ToString());
                X_Total = int.Parse(dr["X_Total"].ToString());
                X_BC = DB.getRowCount("X_Permit", " X_Manager_User='" + X_Manager_User + "' and X_Type='请假'") + (DB.getRowCount("X_Permit", " X_Manager_User='" + X_Manager_User + "' and X_Type='缺勤'"))*2;
                X_XS = 1;
                X_Price = decimal.Parse(dr["X_Price"].ToString());
                X_Subsidy = decimal.Parse(dr["X_Subsidy"].ToString());
                X_Othor = decimal.Parse(dr["X_Othor"].ToString());