private void btnAdd_Click(object sender, EventArgs e)
{
if (txtAi.Text.Trim().Length == 0)
{
MessageBox.Show("类别名称不能为空！");
txtAi.Focus();
return;
}
GoldenLadyWS.Service serivce = new GoldenLadyWS.Service();
bool flag = true;
string sql = "insert into SMSAi (name,forwarddays,sendtime) Values ('" + txtAi.Text.Trim() + "',0,'00:00:00')";
if (serivce.ExecuteCommandText(sql) <= 0)
{
flag = false;
}
int newid = Convert.ToInt32(serivce.GetDataSet("select MAX(id) from SMSAi").Tables[0].Rows[0][0].ToString());
sql = "insert into SMSUsefulExpressions (id,content1) values (" + newid + ",'" + txtUsefulExpressions1.Text.Trim() + "')";
if (serivce.ExecuteCommandText(sql) <= 0)
{
flag = false;
}
if (flag)
{
MessageBox.Show("添加成功！");
this.DialogResult = DialogResult.Yes;
}
else
{
MessageBox.Show("添加失败！");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (txtAi.Text.Trim().Length == 0)
{
MessageBox.Show("类别名称不能为空！");
txtAi.Focus();
return;
}
if (cmbHH.Text.Length == 1)
{
cmbHH.Text = "0" + cmbHH.Text;
}
if (cmbMM.Text.Length == 1)
{
cmbMM.Text = "0" + cmbMM.Text;
}
string sql = "update SMSAi set name='" + txtAi.Text.Trim() + "',forwarddays=" + Convert.ToInt32(cmbForwardDays.Text) + ",sendtime='" + cmbHH.Text + ":" + cmbMM.Text + ":00" + "' where id=" + Convert.ToInt32(id);
bool flag = true;
GoldenLadyWS.Service serivce = new GoldenLadyWS.Service();
if (serivce.ExecuteCommandText(sql) <= 0)
{
flag = false;
}
sql = "update SMSUsefulExpressions set content1='" + txtUsefulExpressions1.Text.Trim() + "' where id=" + Convert.ToInt32(id);
if (serivce.ExecuteCommandText(sql) <= 0)
{
flag = false;
}
if (flag)
{
MessageBox.Show("修改成功！");
frmOption_Load(null, null);
dgv.ClearSelection();
dgv.Rows[selectIndex].Selected = true;
}
else
{
MessageBox.Show("修改失败！！");
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
GoldenLadyWS.Service service = new GoldenLadyWS.Service();
//int Id = Convert.ToInt32(id);
for (int i = 0; i < dgv.SelectedRows.Count; i++)
{
string sql = "delete from SMSAi where id=" + Convert.ToInt32(dgv.SelectedRows[i].Cells[0].Value.ToString());
if (Convert.ToInt32(dgv.SelectedRows[i].Cells["编号"].Value) < 7)
{
continue;
}
if (service.ExecuteCommandText(sql) <= 0)
{
MessageBox.Show("删除失败！");
}
}
frmOption_Load(null, null);//刷新
dgv.ClearSelection();
dgv.Rows[dgv.Rows.Count - 1].Selected = true;
}
private void frmOption_Load(object sender, EventArgs e)
{
GoldenLadyWS.Service service = new GoldenLadyWS.Service();
//string Sql = " select su.id as '编号', name as '通知类别',content1 as '自定义短语1',content2 as '自定义短语2',forwarddays as '提前通知天数',sendtime as '发送时间' from SMSAi sa,SMSUsefulExpressions su where sa.id=su.id";
string Sql = " select su.id as id, name,content1,forwarddays,sendtime from SMSAi sa,SMSUsefulExpressions su where sa.id=su.id";
myds = service.GetDataSet(Sql);
dgv.DataSource = myds.Tables[0];
for (int i = 0; i < dgv.Rows.Count; i++)
{
int id = Convert.ToInt32(dgv.Rows[i].Cells["编号"].Value.ToString());
if (id >= 1 && id <= 6)
{
dgv.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;
}
//2013-01-07 qiuqianquan
string name = dgv.Rows[i].Cells["通知类别"].Value.ToString().Trim();
if (name == "选片预约提醒" || name == "取件预约提醒" || name == "看版预约提醒" || name == "看版取消提醒" || name == "选片取消提醒" || name == "取件取消提醒" || name == "摄影取消提醒" || name == "摄影预约提醒")
{
dgv.Rows[i].DefaultCellStyle.BackColor = Color.Yellow;//摄影取消提醒
}
}
}