//删除
private void DataGridViewDelete(DataGridViewSummary dbView)
{
try
{
int k = dbView.SelectedRows.Count;
if (MessageBox.Show("确实要删除这" + Convert.ToString(k) + "项吗？", "系统提示") == DialogResult.No)
{
}
else
{
if (k != dbView.Rows.Count - 2)
{
for (int i = k; i >= 1; i--)
{
dbView.Rows.RemoveAt(dbView.SelectedRows[i - 1].Index);
}
}
else
{
dbView.Rows.Clear();
}
}
}
catch (Exception ex)
{
}
}
//粘贴
private void DataGridViewCellPaste(DataGridViewSummary dbView)
{
try
{
dtSource.Rows.Clear();
// 获取剪切板的内容，并按行分割
string pasteText = Clipboard.GetText();
if (string.IsNullOrEmpty(pasteText))
{
return;
}
string[] lines = pasteText.Split(new char[] { '\n' });
foreach (string line in lines)
{
if (string.IsNullOrEmpty(line.Trim()))
{
continue;
}
string[] vals = line.Split('\t');
if (string.IsNullOrEmpty(vals[1]))
{
continue;
}
DataRow ndr = dtSource.NewRow();
ndr.ItemArray = vals;
dtSource.Rows.Add(ndr);
}
dbView.DataSource = dtSource;
}
catch (Exception ex)
{
}
}
//复制
private void DataGridViewCellCopy(DataGridViewSummary dbView)
{
try
{
if (dbView.GetCellCount(DataGridViewElementStates.Selected) > 0)
{
try
{
Clipboard.SetDataObject(dbView.GetClipboardContent());
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void delete_fjrb(DataGridViewSummary dg_fjrb, Model.Qskyd_fjrb M_Qskyd_fjrb, BLL.Qskyd_fjrb B_Qskyd_fjrb)
{
common_file.common_app.get_czsj();
if (dg_fjrb.Rows.Count > 0 && dg_fjrb.Rows[0].Cells["id"].Value != null && dg_fjrb.Rows[0].Cells["id"].Value.ToString() != string.Empty)
{
if (dg_fjrb.CurrentRow.Index >= 0 || dg_fjrb.Rows.Count > 0)
{
if (common_file.common_app.message_box_show_select(common_file.common_app.message_title, "你真的要删除所选的记录吗？") == true)
{
string id = dg_fjrb.Rows[dg_fjrb.CurrentRow.Index].Cells["id"].Value.ToString();
M_Qskyd_fjrb = B_Qskyd_fjrb.GetModel(int.Parse(id));
if (M_Qskyd_fjrb != null)
{
if (M_Qskyd_fjrb.fjbh == "" && M_Qskyd_fjrb.fjrb == "")
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "对不起,当前记录只能修改！");
return;
}
if (M_Qskyd_fjrb.fjbh != "" && M_Qskyd_fjrb.fjrb != "")
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "对不起,排房记录不能在此删除！若要删除，请到主单去操作！");
return;
}
if (M_Qskyd_fjrb.fjbh == "" && M_Qskyd_fjrb.fjrb != "")
{
BLL.Common B_Common = new Hotel_app.BLL.Common();
DataSet ds_temp = B_Common.GetList("select * from Qskyd_fjrb", "lsbh='" + M_Qskyd_fjrb.lsbh + "'");
if (ds_temp != null && ds_temp.Tables[0].Rows.Count > 1)
{
common_file.common_app.get_czsj();
string url = common_file.common_app.service_url + "Qyddj/Qyddj_app.asmx";
object[] args = new object[26];
args[0] = id;
args[1] = common_file.common_app.yydh;
args[2] = common_file.common_app.qymc;
args[3] = M_Qskyd_fjrb.lsbh;
args[4] = M_Qskyd_fjrb.krxm;
args[5] = M_Qskyd_fjrb.sktt;
args[6] = M_Qskyd_fjrb.yddj;
args[7] = M_Qskyd_fjrb.fjrb;
args[8] = M_Qskyd_fjrb.fjbh;
args[9] = M_Qskyd_fjrb.ddsj;
args[10] = M_Qskyd_fjrb.lksj;
args[11] = M_Qskyd_fjrb.lzfs;
args[12] = M_Qskyd_fjrb.shqh;
args[13] = M_Qskyd_fjrb.fjjg;
args[14] = M_Qskyd_fjrb.sjfjjg;
args[15] = M_Qskyd_fjrb.yh;
args[16] = M_Qskyd_fjrb.yhbl;
args[17] = M_Qskyd_fjrb.bz;
args[18] = common_file.common_app.czy;
args[19] = DateTime.Now;
args[20] = common_file.common_app.chinese_delete;
args[21] = M_Qskyd_fjrb.yddj;//有三种状态,一种预订、一种登记、一种预订转登记
args[22] = common_file.common_app.get_delete;
args[23] = common_file.common_app.xxzs;
args[24] = "";
args[25] = decimal.Parse("0");
Hotel_app.Server.Qyddj.Qskyd_fjrb_add_edit_delete Qskyd_fjrb_add_edit_delete_services = new Hotel_app.Server.Qyddj.Qskyd_fjrb_add_edit_delete();
string result = Qskyd_fjrb_add_edit_delete_services.Qskyd_fjrb_add_edit_delete_app(args[0].ToString(), args[1].ToString(), args[2].ToString(), args[3].ToString(), args[4].ToString(), args[5].ToString(), args[6].ToString(), args[7].ToString(), args[8].ToString(), DateTime.Parse(args[9].ToString()), DateTime.Parse(args[10].ToString()), Decimal.Parse(args[11].ToString()), args[12].ToString(), Decimal.Parse(args[13].ToString()),
Decimal.Parse(args[14].ToString()), args[15].ToString(), Decimal.Parse(args[16].ToString()), args[17].ToString(), args[18].ToString(), DateTime.Parse(args[19].ToString()), args[20].ToString(), args[21].ToString(), args[22].ToString(), args[23].ToString(), args[24].ToString(), Decimal.Parse(args[25].ToString()));
// object result = Hotel_app.我的替换DynamicWebServiceCall.InvokeWebService(url, "Qskyd_fjrb_add_edit_delete_app", args);
if (result == common_file.common_app.get_suc)
{
dg_fjrb.Rows.Remove(dg_fjrb.CurrentRow);
common_file.common_app.Message_box_show(common_file.common_app.message_title, "删除成功！");
}
else
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "操作失败！");
}
}
else
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "对不起,单条记录不能在此删除！若要删除，请到主单去操作！");
}
}
}
else
{
common_file.common_app.Message_box_show(common_file.common_app.message_title, "你好,找不到相应的记录！");
}
}
}
else
{
//提示
common_file.common_app.Message_box_show(common_file.common_app.message_title, "你好,你没有选择任何信息！");
}
}
Cursor.Current = Cursors.Default;
}
public static void searchButtion_Click(int tempCount, DataTable dt, string tableName, ref int CurrentPage, int PageSize, ref int PageCount, Label l_totalPage, Label l_currentPage, DataGridViewSummary dg_infoSource, string GetSelCond, TabControl tabControl1)
{
common_file.common_app.get_czsj();
tempCount = -1;
dt = DbHelperSQL.CommonPagination(tableName, tableName + ".id", tableName + ".id", CurrentPage, PageSize, "*", GetSelCond, "", ref tempCount);
if ((tempCount % PageSize) == 0)
{
PageCount = tempCount / PageSize;
}
else
{
PageCount = tempCount / PageSize + 1;
}
l_totalPage.Text = PageCount.ToString();
l_currentPage.Text = CurrentPage.ToString();
dg_infoSource.AutoGenerateColumns = false;
dg_infoSource.DataSource = dt;
tabControl1.SelectedIndex = 0;
tabControl1.TabPages[0].Focus();
Cursor.Current = Cursors.Default;
}
/// <summary>
/// 分页代码
/// </summary>
/// <param name="operation"></param>
/// <param name="PageSize"></param>
/// <param name="CurrentPage"></param>
/// <param name="l_totalPage"></param>
/// <param name="l_currentPage"></param>
/// <param name="dt"></param>
/// <param name="tableName"></param>
/// <param name="dg_infoSource"></param>
/// <param name="GetSelCond"></param>
public static void linkButtion_Click(object operation_sender, int PageSize, int PageCount, ref int CurrentPage, Label l_totalPage, Label l_currentPage, DataTable dt, string tableName, DataGridViewSummary dg_infoSource, string GetSelCond)
{
int tempCount = -1;
if ((LinkLabel)operation_sender != null)
{
LinkLabel linklable = operation_sender as LinkLabel;
if (linklable.Name.Equals("lb_first"))
{
CurrentPage = 1;
l_totalPage.Text = PageCount.ToString();
l_currentPage.Text = CurrentPage.ToString();
dt = DbHelperSQL.CommonPagination(tableName, tableName + ".id", tableName + ".id", CurrentPage, PageSize, "*", GetSelCond, "", ref tempCount);
dg_infoSource.DataSource = dt;
}
if (linklable.Name.Equals("lb_pre"))
{
if (CurrentPage >= 2)
{
CurrentPage -= 1;
}
l_totalPage.Text = PageCount.ToString();
l_currentPage.Text = CurrentPage.ToString();
dt = DbHelperSQL.CommonPagination(tableName, tableName + ".id", tableName + ".id", CurrentPage, PageSize, "*", GetSelCond, "", ref tempCount);
dg_infoSource.DataSource = dt;
}
if (linklable.Name.Equals("lb_next"))
{
if (CurrentPage < PageCount)
{
CurrentPage += 1;
}
else
{
CurrentPage = PageCount;
}
l_totalPage.Text = PageCount.ToString();
l_currentPage.Text = CurrentPage.ToString();
dt = DbHelperSQL.CommonPagination(tableName, tableName + ".id", tableName + ".id", CurrentPage, PageSize, "*", GetSelCond, "", ref tempCount);
dg_infoSource.DataSource = dt;
}
if (linklable.Name.Equals("lb_last"))
{
CurrentPage = PageCount;
l_totalPage.Text = PageCount.ToString();
l_currentPage.Text = CurrentPage.ToString();
dt = DbHelperSQL.CommonPagination(tableName, tableName + ".id", tableName + ".id", CurrentPage, PageSize, "*", GetSelCond, "", ref tempCount);
dg_infoSource.DataSource = dt;
}
}
}