private void _create_Click(object sender, RoutedEventArgs e)
{
if (_card_id.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入检疫证号！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
bool exit_flag = dbOperation.GetDbHelper().Exists(string.Format("SELECT count(cardid) from t_certificate where cardid ='{0}'", _card_id.Text));
if (exit_flag)
{
Toolkit.MessageBox.Show("检疫证号已存在，请重新输入！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_help_user.SelectedIndex < 1)
{
Toolkit.MessageBox.Show("请选择协检员！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_shipper_id.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入货主代码！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_object_id.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请选择动物种类！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_object_count.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入数量！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_for_use.SelectedIndex < 1)
{
Toolkit.MessageBox.Show("请选择用途！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_city_ks.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入启运地点:市（州）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_region_ks.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入启运地点:县（市、区）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
//if (_town_ks.Text.Trim().Length == 0)
//{
// Toolkit.MessageBox.Show("请输入启运地点:乡（镇）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
// return;
//}
if (_village_ks.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入启运地点:村（养殖场、交易市场）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_city_js.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入到达地点:市（州）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
//if (_region_js.Text.Trim().Length == 0)
//{
// Toolkit.MessageBox.Show("请输入到达地点:县（市、区）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
// return;
//}
//if (_town_js.Text.Trim().Length == 0)
//{
// Toolkit.MessageBox.Show("请输入到达地点:乡（镇）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
// return;
//}
if (_village_js.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入到达地点:村（养殖场、交易市场）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
string sql = string.Format("INSERT INTO t_certificate(cardid,companyid,companyname,objectid,objectname,objectcount," +
"phone,foruseid,foruse,cityks,regionks,townks,villageks,cityjs,regionjs,townjs," +
"villagejs,objectlable,createdeptid,createuserid,createdate,createloginid,helpuserid)" +
" values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}'," +
"'{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}')"
, _card_id.Text, _shipper_id.Text, _shipper.Text,
(_object_id.SelectedItem as Label).Tag.ToString(), _object_id.Text, _object_count.Text + _object_type.Text,
_phone.Text, (_for_use.SelectedItem as Label).Tag.ToString(), _for_use.Text, _city_ks.Text,
_region_ks.Text, _town_ks.Text, _village_ks.Text, _city_js.Text, _region_js.Text,
_town_js.Text, _village_js.Text, _object_lable.Text, deptId, userId,
System.DateTime.Now, loginid,(_help_user.SelectedItem as Label).Tag.ToString());
int i = dbOperation.GetDbHelper().ExecuteSql(sql);
if (i >= 0)
{
List<string> cer_details = new List<string>() {_card_id.Text,_shipper.Text,_object_id.Text, _object_count.Text,_object_type.Text, _phone.Text,
_for_use.Text, _city_ks.Text, _region_ks.Text, _town_ks.Text, _village_ks.Text, _city_js.Text, _region_js.Text,
_town_js.Text, _village_js.Text, _object_lable.Text,username,loginid,
System.DateTime.Now.Year.ToString(),System.DateTime.Now.Month.ToString(),System.DateTime.Now.Day.ToString() };
UcCertificateDetails cer = new UcCertificateDetails(cer_details);
//grid_info.Children.Add(cer);
PrintDialog dialog = new PrintDialog();
//if (dialog.ShowDialog() == true)
//{
dialog.PrintQueue = GetPrinter();
Size printSize = new Size(dialog.PrintableAreaWidth, dialog.PrintableAreaHeight);
cer.Measure(printSize);
cer.Arrange(new Rect(0, 0, dialog.PrintableAreaWidth, dialog.PrintableAreaHeight));
//Size printSize = new Size(793, 529);
//cer.Measure(printSize);
//cer.Arrange(new Rect(0, 0, 793, 529));
dialog.PrintVisual(cer, "动物检疫证");
//}
//Toolkit.MessageBox.Show("电子出证单生成成功！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
return;
}
else
{
Toolkit.MessageBox.Show("电子出证单生成失败！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
}
private void _create_Click(object sender, RoutedEventArgs e)
{
if (_card_id.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入检疫证号！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
bool exit_flag = dbOperation.GetDbHelper().Exists(string.Format("SELECT count(cardid) from t_certificate where cardid ='{0}'", _card_id.Text));
if (exit_flag)
{
Toolkit.MessageBox.Show("检疫证号已存在，请重新输入！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_help_user.SelectedIndex < 1)
{
Toolkit.MessageBox.Show("请选择协检员！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_shipper_id.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入货主代码！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_object_id.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请选择动物种类！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_object_count.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入数量！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_for_use.SelectedIndex < 1)
{
Toolkit.MessageBox.Show("请选择用途！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_city_ks.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入启运地点:市（州）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_region_ks.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入启运地点:县（市、区）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
//if (_town_ks.Text.Trim().Length == 0)
//{
// Toolkit.MessageBox.Show("请输入启运地点:乡（镇）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
// return;
//}
if (_village_ks.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入启运地点:村（养殖场、交易市场）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
if (_city_js.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入到达地点:市（州）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
//if (_region_js.Text.Trim().Length == 0)
//{
// Toolkit.MessageBox.Show("请输入到达地点:县（市、区）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
// return;
//}
//if (_town_js.Text.Trim().Length == 0)
//{
// Toolkit.MessageBox.Show("请输入到达地点:乡（镇）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
// return;
//}
if (_village_js.Text.Trim().Length == 0)
{
Toolkit.MessageBox.Show("请输入到达地点:村（养殖场、交易市场）！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
string sql = string.Format("INSERT INTO t_certificate(cardid,companyid,companyname,objectid,objectname,objectcount," +
"phone,foruseid,foruse,cityks,regionks,townks,villageks,cityjs,regionjs,townjs," +
"villagejs,objectlable,createdeptid,createuserid,createdate,createloginid,helpuserid)" +
" values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}'," +
"'{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}')"
, _card_id.Text, _shipper_id.Text, _shipper.Text,
(_object_id.SelectedItem as Label).Tag.ToString(), _object_id.Text, _object_count.Text + _object_type.Text,
_phone.Text, (_for_use.SelectedItem as Label).Tag.ToString(), _for_use.Text, _city_ks.Text,
_region_ks.Text, _town_ks.Text, _village_ks.Text, _city_js.Text, _region_js.Text,
_town_js.Text, _village_js.Text, _object_lable.Text, deptId, userId,
System.DateTime.Now, loginid, (_help_user.SelectedItem as Label).Tag.ToString());
int i = dbOperation.GetDbHelper().ExecuteSql(sql);
if (i >= 0)
{
List <string> cer_details = new List <string>()
{
_card_id.Text, _shipper.Text, _object_id.Text, _object_count.Text, _object_type.Text, _phone.Text,
_for_use.Text, _city_ks.Text, _region_ks.Text, _town_ks.Text, _village_ks.Text, _city_js.Text, _region_js.Text,
_town_js.Text, _village_js.Text, _object_lable.Text, username, loginid,
System.DateTime.Now.Year.ToString(), System.DateTime.Now.Month.ToString(), System.DateTime.Now.Day.ToString()
};
UcCertificateDetails cer = new UcCertificateDetails(cer_details);
//grid_info.Children.Add(cer);
PrintDialog dialog = new PrintDialog();
//if (dialog.ShowDialog() == true)
//{
dialog.PrintQueue = GetPrinter();
Size printSize = new Size(dialog.PrintableAreaWidth, dialog.PrintableAreaHeight);
cer.Measure(printSize);
cer.Arrange(new Rect(0, 0, dialog.PrintableAreaWidth, dialog.PrintableAreaHeight));
//Size printSize = new Size(793, 529);
//cer.Measure(printSize);
//cer.Arrange(new Rect(0, 0, 793, 529));
dialog.PrintVisual(cer, "动物检疫证");
//}
//Toolkit.MessageBox.Show("电子出证单生成成功！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
clear();
return;
}
else
{
Toolkit.MessageBox.Show("电子出证单生成失败！", "系统提示", MessageBoxButton.OK, MessageBoxImage.Information);
return;
}
}