private void btn_chuangjian_Click(object sender, EventArgs e)
{
//构造一个团队信息类
JJTuanduiInfo myinfo = new JJTuanduiInfo()
{
_mingcheng = tb_mingcheng.Text.Trim(),
_fuzeren = tb_fuzeren.Text.Trim(),
_chengyuan = tb_chengyuan.Text.Trim(),
_tuanduitupian = JJImageHelper.ConvertImageToBase64(pb_zhaopian.Image),
_gongzuolingyu = tb_lingyu.Text.Trim()
};
if (myinfo._mingcheng.Equals(string.Empty))
{
MessageBox.Show("团队名不能为空！");
return;
}
//添加团队名称，负责人，成员到数据库
bool bb = mycontroller.InsertTuandui(myinfo);
//提示是否保存成功
if (bb)
{
MessageBox.Show("团队创建成功！");
}
//刷新父窗体
//dialog.result赋值
this.DialogResult = DialogResult.OK;
}
private void UCtuandui_Load(object sender, EventArgs e)
{
//清空数据
flp_tuandui.Controls.Clear();
//获得全部团队数据
DataTable mydt = _mycontroller.GetTuandui();
//刷新显示数据，循环构造tuanduixinxi类uctuanduanxiangqing，加入到flp中
for (int i = 0; i < mydt.Rows.Count; i++)
{
var mydr = mydt.Rows[i];
JJTuanduiInfo mytuanduiinfo = new JJTuanduiInfo()
{
_mingcheng = mydr["名称"].ToString(),
_fuzeren = mydr["负责人"].ToString(),
_chengyuan = mydr["成员"].ToString(),
_chuangjianshijian = mydr["创建时间"].ToString(),
_zhuangtai = mydr["状态"].ToString(),
_jiechushijian = mydr["解除时间"].ToString(),
_tuanduitupian = mydr["团队图片"].ToString(),
_gongzuolingyu = mydr["工作领域"].ToString()
};
UCtuanduixiagnqing myuc = new UCtuanduixiagnqing(mytuanduiinfo);
myuc.Updatedate += UCtuandui_Load;
//把刷新窗体事件传给myuc
flp_tuandui.Controls.Add(myuc);
}
}
public WFtuandui(JJTuanduiInfo myinfo)
{
InitializeComponent();
this.tb_mingcheng.Text = myinfo._mingcheng;
this.tb_fuzeren.Text = myinfo._fuzeren;
this.tb_chengyuan.Text = myinfo._chengyuan;
this.pb_zhaopian.Image = JJImageHelper.ConvertBase64ToImage(myinfo._tuanduitupian);
this.tb_lingyu.Text = myinfo._gongzuolingyu;
}
public UCtuanduixiagnqing(JJTuanduiInfo myinfo)
{
InitializeComponent();
_tuanduiinfo = myinfo;
//赋值控件值
this.lbl_tuanduimingcheng.Text = myinfo._mingcheng;
this.lbl_fuzeren.Text = myinfo._fuzeren;
var list_chengyuan = Regex.Split(myinfo._chengyuan, ",").ToList();
list_chengyuan.Remove("");
this.lbl_renshu.Text = list_chengyuan.Count.ToString();
this.pb_tuandui.Image = JJImageHelper.ConvertBase64ToImage(myinfo._tuanduitupian);
}
/// <summary>
/// 新建团队到数据库中
/// </summary>
/// <param name="tuandui"></param>
/// <param name="fuzeren"></param>
/// <param name="chengyuan"></param>
/// <returns></returns>
public bool InsertTuandui(JJTuanduiInfo myinfo)
{
//判断是否已经存在了这个团队，如果存在那么就做修改，如果不存在就做插入
string str_sql = $"select count(*) from jjdbrenwutaizhang.jjtuandui where 名称='{myinfo._mingcheng}' and 状态='工作中' ";
int num = Convert.ToInt32(mysqlhelper.ExecuteScalar(str_sql, null));
if (num > 0)
{
str_sql = $"update jjtuandui set 名称='{myinfo._mingcheng}',负责人='{myinfo._fuzeren}',成员='{myinfo._chengyuan}',团队图片='{myinfo._tuanduitupian}',工作领域='{myinfo._gongzuolingyu}' where 名称='{myinfo._mingcheng}' and 状态='工作中'";
}
else
{
str_sql = $"insert into jjdbrenwutaizhang.jjtuandui values('{myinfo._mingcheng}'," +
$"'{myinfo._fuzeren}','{myinfo._chengyuan}','{DateTime.Now.ToString()}','工作中','--'," +
$"'{myinfo._tuanduitupian}','{myinfo._gongzuolingyu}')";
}
int num2 = mysqlhelper.ExecuteNonQuery(str_sql, null);
return(num2 > 0 ? true : false);
}
