コード例 #1
0
    protected void BtnSave_Click(object sender, EventArgs e)
    {
        DatumLogic      datumLogic  = new DatumLogic();
        MeasureDataInfo measureInfo = this.GetMeasureInfo();

        if (this._Type == "Add")
        {
            int num = MeasureDataAction.MeasureAdd(measureInfo);
            if (num == 1)
            {
                int maxID = datumLogic.getMaxID("Prj_TechnologyManage", "ID");
                if (maxID > 0)
                {
                    if (this.cbkmark.Checked)
                    {
                        datumLogic.UpdateByID("Prj_TechnologyManage", "[mark]=3 ,filesType=" + int.Parse(this.DDTClass.SelectedValue.ToString()) + " ", "ID", maxID.ToString(), null);
                    }
                    else
                    {
                        datumLogic.UpdateByID("Prj_TechnologyManage", "[mark]=2 ,filesType=" + int.Parse(this.DDTClass.SelectedValue.ToString()) + " ", "ID", maxID.ToString(), null);
                    }
                }
                base.RegisterScript("top.ui.tabSuccess({ parentName: '" + this.parentName + "' });");
                this.BtnSave.Enabled = false;
                return;
            }
            base.RegisterScript("top.ui.show('保存失败')");
            return;
        }
        else
        {
            int num = MeasureDataAction.MeasureUpd(measureInfo);
            if (num == 1)
            {
                int id = measureInfo.Id;
                if (id > 0)
                {
                    if (this.cbkmark.Checked)
                    {
                        datumLogic.UpdateByID("Prj_TechnologyManage", "[mark]=3 ,filesType=" + int.Parse(this.DDTClass.SelectedValue.ToString()) + " ", "ID", id.ToString(), null);
                    }
                    else
                    {
                        datumLogic.UpdateByID("Prj_TechnologyManage", "[mark]=2 ,filesType=" + int.Parse(this.DDTClass.SelectedValue.ToString()) + " ", "ID", id.ToString(), null);
                    }
                }
                base.RegisterScript("top.ui.tabSuccess({ parentName: '" + this.parentName + "' });");
                return;
            }
            base.RegisterScript("top.ui.show('保存失败')");
            return;
        }
    }
コード例 #2
0
ファイル: HighlightsList.aspx.cs プロジェクト: zxl881203/src
    protected void BtnDelete_Click(object sender, EventArgs e)
    {
        List <string> list = new List <string>();

        if (this.Hidden1.Value.Contains("["))
        {
            list = JsonHelper.GetListFromJson(this.Hidden1.Value);
        }
        else
        {
            list.Add(this.Hidden1.Value);
        }
        StringBuilder stringBuilder = new StringBuilder();

        for (int i = 0; i < list.Count; i++)
        {
            if (list[i].ToString() != "")
            {
                if (list.Count - 1 == i)
                {
                    stringBuilder.Append("'").Append(list[i].ToString()).Append("'");
                }
                else
                {
                    stringBuilder.Append("'").Append(list[i].ToString()).Append("',");
                }
            }
        }
        DatumLogic datumLogic = new DatumLogic();

        if (datumLogic.DeleteList(stringBuilder.ToString()))
        {
            this.JS.Text = "alert('操作成功!');";
            this.Data_Bind();
            return;
        }
        this.JS.Text = "alert('操作失败,网络连接故障,请稍候再试')";
    }
コード例 #3
0
ファイル: HighlightsList.aspx.cs プロジェクト: zxl881203/src
    protected void btnFiles_Click(object sender, EventArgs e)
    {
        this.GET_SelectRow();
        string text = string.Empty;

        if (this.ViewState["i_id"] != null)
        {
            text = this.ViewState["i_id"].ToString();
        }
        if (text != "")
        {
            using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
            {
                sqlConnection.Open();
                SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
                DatumLogic     datumLogic     = new DatumLogic();
                try
                {
                    if (datumLogic.UpdateByID(HighlightsList.table_name, "i_id", text, sqlTransaction))
                    {
                        string[] array = text.Split(new char[]
                        {
                            ','
                        });
                        if (array.Length > 0)
                        {
                            for (int i = 0; i < array.Length; i++)
                            {
                                if (!string.IsNullOrEmpty(array[i].ToString()))
                                {
                                    if (this.flc.Exists(array[i].ToString(), sqlTransaction))
                                    {
                                        this.flc.Update(array[i].ToString(), 1, HighlightsList.table_name, sqlTransaction);
                                    }
                                    else
                                    {
                                        if (this.ViewState[HighlightsList.temTable] != null)
                                        {
                                            DataTable dataTable = this.ViewState[HighlightsList.temTable] as DataTable;
                                            foreach (DataRow dr in dataTable.Rows)
                                            {
                                                filesModel filesModel = new filesModel();
                                                filesModel = this.flc.getModelByRow(dr);
                                                if (filesModel.file_sid == array[i].ToString())
                                                {
                                                    this.flc.Add(filesModel, sqlTransaction);
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                        sqlTransaction.Commit();
                        this.JS.Text = "alert('操作成功!');";
                        this.Data_Bind();
                    }
                }
                catch (Exception)
                {
                    sqlTransaction.Rollback();
                    base.RegisterScript("alert('系统提示:\\n\\n操作失败!');");
                }
            }
        }
    }
コード例 #4
0
    protected void btnFiles_Click(object sender, EventArgs e)
    {
        this.GET_SelectRow();
        string text = string.Empty;

        if (this.ViewState["i_id"] != null)
        {
            text = this.ViewState["i_id"].ToString();
        }
        if (text != "")
        {
            using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString))
            {
                sqlConnection.Open();
                SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
                DatumLogic     datumLogic     = new DatumLogic();
                try
                {
                    if (datumLogic.UpdateByID(EPC_17_Ppm_ScienceInnovate_EngineerConfirmList.table_name, 1, "ID", text, sqlTransaction))
                    {
                        string[] array = text.Split(new char[]
                        {
                            ','
                        });
                        if (array.Length > 0)
                        {
                            for (int i = 0; i < array.Length; i++)
                            {
                                if (!string.IsNullOrEmpty(array[i].ToString()))
                                {
                                    if (this.flc.Exists(array[i].ToString(), sqlTransaction))
                                    {
                                        this.flc.Update(array[i].ToString(), 1, EPC_17_Ppm_ScienceInnovate_EngineerConfirmList.table_name, sqlTransaction);
                                    }
                                    else
                                    {
                                        if (this.ViewState[EPC_17_Ppm_ScienceInnovate_EngineerConfirmList.temTable] != null)
                                        {
                                            DataTable dataTable = this.ViewState[EPC_17_Ppm_ScienceInnovate_EngineerConfirmList.temTable] as DataTable;
                                            foreach (DataRow dr in dataTable.Rows)
                                            {
                                                filesModel filesModel = new filesModel();
                                                filesModel = this.flc.getModelByRow(dr);
                                                if (filesModel.file_sid == array[i].ToString())
                                                {
                                                    this.flc.Add(filesModel, sqlTransaction);
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                        sqlTransaction.Commit();
                        base.RegisterScript("top.ui.show('操作成功!')");
                        this.MeasureBind(this._PrjCode, this._BigSort, this._SmallSort);
                    }
                }
                catch (Exception ex)
                {
                    ex.ToString();
                    sqlTransaction.Rollback();
                    sqlConnection.Close();
                    base.RegisterScript("top.ui.show('操作失败!');");
                }
            }
        }
    }
コード例 #5
0
    protected void Button_save_Click(object sender, EventArgs e)
    {
        if (this.TextBox_cfyj.Text.Length > this.TextBox_cfyj.MaxLength)
        {
            this.JavaScriptControl1.Text = "alert('奖罚依据输入内容过长!')";
            return;
        }
        if (this.TextBox_cfyy.Text.Length > this.TextBox_cfyy.MaxLength)
        {
            this.JavaScriptControl1.Text = "alert('奖罚原因输入内容过长!')";
            return;
        }
        if (this.Textbox_bz.Text.Length > this.Textbox_bz.MaxLength)
        {
            this.JavaScriptControl1.Text = "alert('备注输入内容过长!')";
            return;
        }
        ItemProgInfo itemProgInfo = new ItemProgInfo();

        if (!string.IsNullOrWhiteSpace(this.pk))
        {
            itemProgInfo.ID = int.Parse(this.pk);
        }
        itemProgInfo.ApproveResult = 0;
        itemProgInfo.ByProgObject  = this.TextBox_bcfdx.Text.Trim();
        itemProgInfo.Remark        = this.Textbox_bz.Text.Trim();
        itemProgInfo.ProgUnit      = this.TextBox_cfdw.Text;
        if (this.Textbox_cfje.Text.Trim() != "")
        {
            itemProgInfo.ProgMoney = decimal.Parse(this.Textbox_cfje.Text.Trim());
        }
        if (this.Textbox_cfrq.Text.Trim() != "")
        {
            itemProgInfo.ProgDate = DateTime.Parse(this.Textbox_cfrq.Text.Trim());
        }
        itemProgInfo.ProgGist      = this.TextBox_cfyj.Text.Trim();
        itemProgInfo.ProgCause     = this.TextBox_cfyy.Text.Trim();
        itemProgInfo.Principal     = this.Textbox_fzr.Text.Trim();
        itemProgInfo.ProgBurstunit = this.Textbox_cfdkcdw.Text.Trim();
        if (base.Request["Levels"] != null)
        {
            itemProgInfo.ProgSign = int.Parse(base.Request["Levels"].ToString());
        }
        if (base.Request["Prjcode"] != null)
        {
            itemProgInfo.PrjCode = base.Request["Prjcode"].ToString();
        }
        if (this.DropDownList_lb.SelectedValue != "")
        {
            itemProgInfo.ProgSortCode = int.Parse(this.DropDownList_lb.SelectedValue);
        }
        string sqlString = string.Empty;
        bool   flag;

        if (string.IsNullOrWhiteSpace(this.pk))
        {
            flag = ItemProgAction.ItemProgInfoOp(itemProgInfo, "Insert");
            DatumLogic datumLogic = new DatumLogic();
            int        maxID      = datumLogic.getMaxID("Prj_ItemProg", "ID");
            if (this.cbkmark.Checked)
            {
                sqlString = string.Concat(new object[]
                {
                    "UPDATE Prj_ItemProg SET filesType = ",
                    this.DDTClass.SelectedValue,
                    ",[mark] = 3 WHERE ID=",
                    maxID
                });
            }
            else
            {
                sqlString = string.Concat(new object[]
                {
                    "UPDATE Prj_ItemProg SET filesType = ",
                    this.DDTClass.SelectedValue,
                    ",[mark] = 2 WHERE ID=",
                    maxID
                });
            }
        }
        else
        {
            flag = ItemProgAction.ItemProgInfoOp(itemProgInfo, "Update");
            if (this.cbkmark.Checked)
            {
                sqlString = string.Concat(new object[]
                {
                    "UPDATE Prj_ItemProg SET filesType = ",
                    this.DDTClass.SelectedValue,
                    ",[mark] = 3 WHERE ID=",
                    itemProgInfo.ID
                });
            }
            else
            {
                sqlString = string.Concat(new object[]
                {
                    "UPDATE Prj_ItemProg SET filesType = ",
                    this.DDTClass.SelectedValue,
                    ",[mark] = 2 WHERE ID=",
                    itemProgInfo.ID
                });
            }
        }
        if (flag)
        {
            publicDbOpClass.ExecSqlString(sqlString);
            base.RegisterScript("top.ui.tabSuccess({ parentName: '_ItemProgManage' })");
            return;
        }
        this.JavaScriptControl1.Text = "alert('保存失败!');";
    }
コード例 #6
0
ファイル: TechnologyTellLogic.cs プロジェクト: zxl881203/src
        public int GetMaxId()
        {
            DatumLogic logic = new DatumLogic();

            return(logic.getMaxID("Prj_TechnologyTell", "MainID"));
        }