/// <summary>
/// 确定添加窗口按钮点击
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_win_add_win_btn(object sender, RoutedEventArgs e)
{
T_Jinpo mode = new T_Jinpo();
mode.JinpoName = JinpoNamestr.Text;
mode.JinpoID = JinpoIDstr.Text;
mode.JinpoIDCar = JinpoIDCarstr.Text;
try
{
mode.JinpoManey = Convert.ToInt32(JinpoManeyint.Text);
}
catch (Exception ex)
{
MessageBox.Show("请输入正确的金额！重试");
return;
}
mode.JinpoPayState = combox_1.Text;
mode.JinpoAttendState = combox_2.Text;
mode.JinpoPhone = JinpoPhonestr.Text;
D_Jinpo Djinpo = new D_Jinpo();
bool GetResult = Djinpo.AddedWin_Add(mode);
if (GetResult)
{
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("添加失败");
}
this.Close();
}
//鼠标点击查看DataGrid列表一列
private void OrderinfodataGrid_Click(object sender, MouseButtonEventArgs e)
{
DataGrid dg = sender as DataGrid;
var cell = dg.CurrentCell;
try
{
int ID = ((Model.Models.T_Jinpo)cell.Item).ID;
IDnumber = ID;
D_Jinpo Idmode = new D_Jinpo();
T_Jinpo tjmodel = new T_Jinpo();
tjmodel = Idmode.scanmodelData(ID);
NAME_one.Text = tjmodel.JinpoName;
input_ID.Text = Convert.ToString(tjmodel.ID);
one_num.Text = tjmodel.JinpoID;
two_num.Text = tjmodel.JinpoIDCar;
one_state.Text = tjmodel.JinpoPayState;
two_state.Text = tjmodel.JinpoAttendState;
phonenumber.Text = tjmodel.JinpoPhone;
}
catch (Exception ex)
{
MessageBox.Show("指定对象失败！");
}
//if (item != null)
//{
// string Text = item[cell.Column.DisplayIndex].ToString();
//}
}
/// <summary>
/// 数据更新操作
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool EditedWin_Updata(T_Jinpo model)
{
bool result = false;
using (SqlConnection conn = new SqlConnection(constr))
{
try
{
conn.Open();
}
catch (Exception ex)
{
}
string sqlstr_EditedWin_Updata = @"
UPDATE T_Jinpo
SET
JinpoName = @JinpoName,
JinpoID = @JinpoID,
JinpoIDCar = @JinpoIDCar,
JinpoManey =@JinpoManey,
JinpoPhone =@JinpoPhone,
JinpoPayState = @JinpoPayState,
JinpoAttendState = @JinpoAttendState
WHERE ID=@ID
";
using (SqlCommand com = new SqlCommand())
{
com.Connection = conn;
com.CommandText = sqlstr_EditedWin_Updata;
com.Parameters.Add(new SqlParameter("@ID", model.ID));
com.Parameters.Add(new SqlParameter("@JinpoName", model.JinpoName));
com.Parameters.Add(new SqlParameter("@JinpoID", model.JinpoID));
com.Parameters.Add(new SqlParameter("@JinpoIDCar", model.JinpoIDCar));
com.Parameters.Add(new SqlParameter("@JinpoManey", model.JinpoManey));
com.Parameters.Add(new SqlParameter("@JinpoPhone", model.JinpoPhone));
com.Parameters.Add(new SqlParameter("@JinpoPayState", model.JinpoPayState));
com.Parameters.Add(new SqlParameter("@JinpoAttendState", model.JinpoAttendState));
try
{
result = com.ExecuteNonQuery() > 0;
if (result)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
}
}
return(result);
}
/// <summary>
/// 查找一个对象model
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public T_Jinpo scanmodelData(int id)
{
T_Jinpo tmodel = new T_Jinpo();
using (SqlConnection conn = new SqlConnection(constr))
{
try
{
conn.Open();
}
catch (Exception e)
{
}
string sqlstr_scanmodeldata = @"
SELECT *
FROM dbo.T_Jinpo
WHERE ID = @ID
";
using (SqlCommand com = new SqlCommand())
{
com.Connection = conn;
com.CommandText = sqlstr_scanmodeldata;
com.Parameters.Add(new SqlParameter("@ID", id));
try
{
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
T_Jinpo newjinpo = new T_Jinpo();
newjinpo.ID = Convert.ToInt32(dr["ID"]);
newjinpo.JinpoManey = Convert.ToInt32(dr["JinpoManey"]);
newjinpo.JinpoAttendState = Convert.ToString(dr["JinpoAttendState"]);
newjinpo.JinpoID = Convert.ToString(dr["JinpoID"]);
newjinpo.JinpoIDCar = Convert.ToString(dr["JinpoIDCar"]);
newjinpo.JinpoName = Convert.ToString(dr["JinpoName"]);
newjinpo.JinpoPayState = Convert.ToString(dr["JinpoPayState"]);
newjinpo.JinpoPhone = Convert.ToString(dr["JinpoPhone"]);
tmodel = newjinpo;
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
}
}
return(tmodel);
}
/// <summary>
/// 主界面背景数据查询
/// </summary>
/// <returns></returns>
public List <T_Jinpo> BlackGroundData_Query()
{
List <T_Jinpo> modelist = new List <T_Jinpo>();
using (SqlConnection con = new SqlConnection(constr))
{
try
{
con.Open();
}
catch (Exception ex)
{
}
string sqlstr_blackgrounddata_query = @"
SELECT *
FROM dbo.T_Jinpo
";
using (SqlCommand com = new SqlCommand())
{
com.Connection = con;
com.CommandText = sqlstr_blackgrounddata_query;
try
{
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
T_Jinpo mode = new T_Jinpo();
mode.ID = Convert.ToInt32(dr["ID"]);
mode.JinpoName = dr["JinpoName"].ToString();
mode.JinpoID = dr["JinpoID"].ToString();
mode.JinpoIDCar = dr["JinpoIDCar"].ToString();
mode.JinpoManey = Convert.ToInt32(dr["JinpoManey"]);
mode.JinpoPhone = dr["JinpoPhone"].ToString();
mode.JinpoPayState = dr["JinpoPayState"].ToString();
mode.JinpoAttendState = dr["JinpoAttendState"].ToString();
modelist.Add(mode);
}
}
catch (Exception ex)
{ }
finally
{
con.Close();
}
}
}
return(modelist);
}
/// <summary>
/// 数据初始化
/// </summary>
public void InitializationData()
{
D_Jinpo Idmode = new D_Jinpo();
T_Jinpo tjmodel = new T_Jinpo();
tjmodel = Idmode.scanmodelData(IDnumber);
inputName.Text = tjmodel.JinpoName;
IDnumber = tjmodel.ID;
inputJinpoID.Text = tjmodel.JinpoID;
inputJinpoIDCar.Text = tjmodel.JinpoIDCar;
JinpoPayState_Text.Text = tjmodel.JinpoPayState;
input_PayMoney.Text = tjmodel.JinpoManey.ToString();
JinpoAttendState_Text.Text = tjmodel.JinpoAttendState;
inputJinpoPhone.Text = tjmodel.JinpoPhone;
}
/// <summary>
/// 执行更新更改
/// </summary>
public void updateWinDatal()
{
D_Jinpo Djinpo = new D_Jinpo();
T_Jinpo model = new T_Jinpo();
model.ID = IDnumber; //ID
model.JinpoName = inputName.Text; //姓名
model.JinpoID = inputJinpoID.Text; //档案号
model.JinpoIDCar = inputJinpoIDCar.Text; //身份证号
model.JinpoManey = Convert.ToInt32(input_PayMoney.Text); //缴费金额
if (btn1 == 1)
{
model.JinpoPayState = JinpoPayState_Combo.Text;//缴费方式
}
else
{
model.JinpoPayState = JinpoPayState_Text.Text;//缴费方式
}
if (btn2 == 1)
{
model.JinpoAttendState = JinpoAttendState_Combo.Text;//社保方式
}
else
{
model.JinpoAttendState = JinpoAttendState_Text.Text;//社保方式
}
model.JinpoPhone = inputJinpoPhone.Text;//联系方式
bool GetResult = Djinpo.EditedWin_Updata(model);
if (GetResult)
{
MessageBox.Show("数据更新成功");
}
else
{
MessageBox.Show("数据操作失败");
}
}
/// <summary>
/// 主界面查询按钮
/// </summary>
/// <param name="select"></param>
/// <param name="inputstr"></param>
/// <returns></returns>
public List <T_Jinpo> BlackGroundData_Btn_Query(string select, string inputstr)
{
List <T_Jinpo> modellist = new List <T_Jinpo>();
using (SqlConnection conn = new SqlConnection(constr))
{
try
{
conn.Open();
}
catch (Exception ex)
{
}
string sqlstr_name = @"
SELECT *
FROM dbo.T_Jinpo
WHERE JinpoName = @JinpoName
";
string sqlstr_ID = @"
SELECT *
FROM dbo.T_Jinpo
WHERE ID = @ID
";
using (SqlCommand com = new SqlCommand())
{
com.Connection = conn;
if (select == "个人编号")//ID
{
com.CommandText = sqlstr_ID;
com.Parameters.Add(new SqlParameter("@ID", inputstr));
}
else//姓名Name
{
com.CommandText = sqlstr_name;
com.Parameters.Add(new SqlParameter("@JinpoName", inputstr));
}
try
{
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
T_Jinpo mode = new T_Jinpo();
mode.ID = Convert.ToInt32(dr["ID"]);
mode.JinpoName = dr["JinpoName"].ToString();
mode.JinpoID = dr["JinpoID"].ToString();
mode.JinpoIDCar = dr["JinpoIDCar"].ToString();
mode.JinpoManey = Convert.ToInt32(dr["JinpoManey"]);
mode.JinpoPhone = dr["JinpoPhone"].ToString();
mode.JinpoPayState = dr["JinpoPayState"].ToString();
mode.JinpoAttendState = dr["JinpoAttendState"].ToString();
modellist.Add(mode);
}
dr.Close();
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
}
}
return(modellist);
}
/// <summary>
/// 数据添加操作
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddedWin_Add(T_Jinpo model)
{
bool result = false;
using (SqlConnection conn = new SqlConnection(constr))
{
try
{
conn.Open();
}
catch (Exception ex)
{
}
string sqlstr_addedWin_add = @"
INSERT dbo.T_Jinpo
(
JinpoName ,
JinpoID ,
JinpoIDCar ,
JinpoManey ,
JinpoPhone ,
JinpoPayState ,
JinpoAttendState
)
VALUES (
@JinpoName,
@JinpoID,
@JinpoIDCar,
@JinpoManey,
@JinpoPhone,
@JinpoPayState,
@JinpoAttendState
)
";
using (SqlCommand com = new SqlCommand())
{
com.Connection = conn;
com.CommandText = sqlstr_addedWin_add;
com.Parameters.Add(new SqlParameter("@JinpoName", model.JinpoName));
com.Parameters.Add(new SqlParameter("@JinpoID", model.JinpoID));
com.Parameters.Add(new SqlParameter("@JinpoIDCar", model.JinpoIDCar));
com.Parameters.Add(new SqlParameter("@JinpoManey", model.JinpoManey));
com.Parameters.Add(new SqlParameter("@JinpoPhone", model.JinpoPhone));
com.Parameters.Add(new SqlParameter("@JinpoPayState", model.JinpoPayState));
com.Parameters.Add(new SqlParameter("@JinpoAttendState", model.JinpoAttendState));
try
{
result = com.ExecuteNonQuery() > 0;
if (result)
{
result = true;
}
else
{
result = false;
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
}
}
return(result);
}
