public void Insert(int FK_OrderID, int FK_StatusVisitID, int FK_StatusOrderID, double?LatitudeAddress, double?LogitudeAddress)
{
int?causeID = null;
var NegocioOrder = new BusinessOrder();
var order = NegocioOrder.GetByID(FK_OrderID);
if (order != null)
{
causeID = order.PreOrder != true ? null : (int?)47;
}
var objRepository = new RepositoryVisit();
EntityVisit data = new EntityVisit()
{
PK_VisitID = 0,
FK_OrderID = FK_OrderID,
FK_StatusVisitID = FK_StatusVisitID,
FK_StatusOrderID = FK_StatusOrderID,
FK_CauseOrderID = causeID,
SequenceVisit = null,
StartVisitDate = null,
EndVisitDate = null,
StartOrderDate = null,
EndOrderDate = null,
StartServiceDate = null,
EndServiceDate = null,
LatitudeAddress = Convert.ToSingle(LatitudeAddress),
LogitudeAddress = Convert.ToSingle(LogitudeAddress),
LatitudeStartVisit = null,
LogitudeStartVisit = null,
LatitudeEndVisit = null,
LogitudeEndVisit = null,
LatitudeStartOrder = null,
LogitudeStartOrder = null,
LatitudeEndOrder = null,
LogitudeEndOrder = null,
DurationVisit = null,
DurationOrder = null,
DurationExecute = null,
DurationTransport = null,
NoteVisit = "",
NoteOrder = "",
Status = true,
CreateDate = DateTime.Now,
ModifyDate = DateTime.UtcNow
};
data = objRepository.Insert(data);
}
/// <summary>
/// Method called when a process token executes the step.
/// </summary>
public ExitType Execute(IStepExecutionContext context)
{
if (string.IsNullOrEmpty(_efConnectString))
{
string sqlInstance = PropertyHelper.GetString(context, "SqlInstance");
string sqlDbName = PropertyHelper.GetString(context, "SqlDbName");
// The name of the Entity Framework Model that we created.
string efModel = "SimioServerModel";
_efConnectString = EntityFrameworkHelpers.BuildEfConnectionString(sqlInstance, sqlDbName, efModel);
string startDt = PropertyHelper.GetString(context, "StartDateTime");
_dtStart = DateTime.Parse(startDt);
string sqlConnectString = EntityFrameworkHelpers.BuildDbConnectionString(sqlInstance, sqlDbName);
using (SqlConnection sqlConn = new SqlConnection(sqlConnectString))
{
sqlConn.Open();
using (SqlCommand cmd = new SqlCommand("DELETE * FROM EntityVisits WHERE 1=1"))
{
int nn = cmd.ExecuteNonQuery();
}
}
}
var entity = context.AssociatedObject;
using (SimioCalculationStepSample2Entities efContext = new SimioCalculationStepSample2Entities(_efConnectString))
{
var server = efContext.Servers.SingleOrDefault(rr => rr.Name == "");
// First see if this Enity exists
EntityVisit ev = new EntityVisit();
ev.EntityId = EntityFrameworkHelpers.BuildEntityKey(entity.HierarchicalDisplayName);
ev.ArrivalTime = _dtStart.AddSeconds(context.Calendar.TimeNow);
ev.DepartureTime = null;
efContext.EntityVisits.Add(ev);
efContext.SaveChanges();
}
return(ExitType.FirstExit);
}
public int InsertVisit(EntityVisit entityVisit)
{
string SqlStr = "";
SqlStr = "insert into tc_visit";
SqlStr += " values('"
+ entityVisit.Visit_output_code + "','"
+ entityVisit.Visit_date + "','"
+ entityVisit.Staff_name.Trim() + "','"
+ entityVisit.Visit_man.Trim() + "','"
+ entityVisit.Visit_usage.Trim() + "','"
+ entityVisit.Visit_opinion.Trim() + "','"
+ entityVisit.Visit_remarks + "')";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
public int UpdateVisit(EntityVisit entityVisit)
{
string SqlStr = "";
SqlStr = "update tc_visit set ";
SqlStr += "visit_date = '" + entityVisit.Visit_date + "' ";
SqlStr += ",staff_name = '" + entityVisit.Staff_name.Trim() + "' ";
SqlStr += ",visit_man = '" + entityVisit.Visit_man.Trim() + "' ";
SqlStr += ",visit_output_code = '" + entityVisit.Visit_output_code.Trim() + "' ";
SqlStr += ",visit_usage = '" + entityVisit.Visit_usage.Trim() + "' ";
SqlStr += ",visit_opinion = '" + entityVisit.Visit_opinion.Trim() + "' ";
SqlStr += ",visit_remarks = '" + entityVisit.Visit_remarks.Trim() + "' ";
SqlStr += " where visit_id = '" + entityVisit.Visit_id + "' ";
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandText = SqlStr;
ExcuteSql(sqlCommand);
return(Constants.SystemConfig.SERVER_SUCCESS);
}
//***********************************************************************
/// <summary>
/// 保存按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <history>
/// 完成信息：李梓楠 2010/11/14 完成
/// 更新信息：
/// </history>
//***********************************************************************
private void btnCommit_Click(object sender, EventArgs e)
{
if (txtOutput_code.Text.Trim() == string.Empty || txtOutput_code.Text == "双击选择出库编号...")
{
MessageBox.Show("出库编号不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtOutput_code.Focus();
return;
}
//判断注册证号不能为空
if (txtVisit_Man.Text.Trim() == string.Empty)
{
MessageBox.Show("被访人不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtVisit_Man.Focus();
return;
}
//判断生产厂家不能为空
if (txtStaff_name.Text.Trim() == string.Empty || txtStaff_name.Text == "双击选择回访人...")
{
MessageBox.Show("双击选择回访人！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtStaff_name.Focus();
return;
}
//判断规格型号不能为空
if (txtVisit_opinion.Text.Trim() == string.Empty)
{
MessageBox.Show("使用意见不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtVisit_opinion.Focus();
return;
}
if (txtUsage.Text.Trim() == string.Empty)
{
MessageBox.Show("使用情况不能为空！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
txtUsage.Focus();
return;
}
//日期校验
if (dateVisit.Value.Date > DateTime.Now)
{
MessageBox.Show("回访日期不能大于今天！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateVisit.Focus();
return;
}
if (dateVisit.Value.Date < sellDate)
{
MessageBox.Show("回访日期不能小于销售日期！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
dateVisit.Focus();
return;
}
//判断非法字符
foreach (Control control in groupBox2.Controls)
{
if (control is TextBox)
{
if (Util.CheckRegex(control.Text.Trim()) && !((TextBox)control).ReadOnly)
{
MessageBox.Show("不可以输入非法字符，请重新输入！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
control.Focus();
return;
}
}
}
EntityVisit entityVisit = new EntityVisit();
try
{
result = -1;
//如果是添加
if (dataType == DataType.Insert)
{
entityVisit.Visit_output_code = txtOutput_code.Text;
entityVisit.Visit_date = dateVisit.Value.Date;
entityVisit.Staff_name = txtStaff_name.Text;
entityVisit.Visit_man = txtVisit_Man.Text;
entityVisit.Visit_opinion = txtVisit_opinion.Text;
entityVisit.Visit_usage = txtUsage.Text;
entityVisit.Visit_remarks = txtVisit_remarks.Text;
dataAccess = new DataAccess();
dataAccess.Open();
GetData getData = new GetData(dataAccess.Connection);
result = getData.InsertVisit(entityVisit);
}
//如果是更新
else if (dataType == DataType.Update)
{
//给选中行赋值
countNum = dgv.SelectedRows[0].Index;
entityVisit.Visit_id = Convert.ToInt32(dgv.SelectedRows[0].Cells["visit_id"].Value.ToString());
entityVisit.Visit_output_code = txtOutput_code.Text;
entityVisit.Visit_date = dateVisit.Value.Date;
entityVisit.Staff_name = txtStaff_name.Text;
entityVisit.Visit_man = txtVisit_Man.Text;
entityVisit.Visit_opinion = txtVisit_opinion.Text;
entityVisit.Visit_usage = txtUsage.Text;
entityVisit.Visit_remarks = txtVisit_remarks.Text;
dataAccess = new DataAccess();
dataAccess.Open();
dataAccess.BeginTransaction();
GetData getData = new GetData(dataAccess.Connection, dataAccess.Transaction);
//取得结果符
result = getData.UpdateVisit(entityVisit);
//提交事务
dataAccess.Commit();
}
}
catch (Exception ex)
{
if (dataAccess.Transaction != null)
{
//回滚
dataAccess.Rollback();
}
//提示错误
MessageBox.Show("数据添加时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
throw ex;
}
finally
{
//关闭数据库连接
dataAccess.Close();
}
if (result == 0)
{
MessageBox.Show("数据已经保存成功！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
BandingDgv();
}
else
{
MessageBox.Show("数据保存时发生错误，请检查数据库！", Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
//设置按钮状态
dataType = DataType.None;
setButtonState();
}
public void Update(EntityVisit visit)
{
new RepositoryVisit().Update(visit);
}
public static void Update(EntityVisit visit)
{
new BusinessVisit().Update(visit);
}
