/// <summary>
/// 插入
/// </summary>
/// <param name="data"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int insertTimeAttendance_AttendanceInformation_machineDal(TimeAttendance_AttendanceInformation_machine data, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@MachineID", SqlDbType.VarChar, 50)
{
Value = data.MachineID
},
new SqlParameter("@ComInterface", SqlDbType.VarChar, 50)
{
Value = data.ComInterface
},
new SqlParameter("@BaudRate", SqlDbType.VarChar, 50)
{
Value = data.BaudRate
},
new SqlParameter("@IPAddress", SqlDbType.VarChar, 50)
{
Value = data.IPAddress
},
new SqlParameter("@MachinePosition", SqlDbType.VarChar, 80)
{
Value = data.MachinePosition
},
new SqlParameter("@MachineUse", SqlDbType.VarChar, 50)
{
Value = data.MachineUse
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
private void btn_ClearData_Click(object sender, EventArgs e)
{
if (dataList.Count <= 0)
{
MessageBox.Show("无获取数据的机器，请添加!");
return;
}
TimeAttendance_AttendanceInformation_machine data = dataList[dataGridViewX1.CurrentRow.Index];
if (data == null)
{
return;
}
if (axCZKEM1.Connect_Net(data.IPAddress, 4370))
{
if (MessageBox.Show("是否删除此机器内的考勤记录？", "系统提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
{
G.Setlb_QueryState("正在删除...");
if (axCZKEM1.ClearGLog(Convert.ToInt32(data.MachineID)))
{
G.Setlb_QueryState("完成");
}
else
{
MessageBox.Show("删除失败");
}
}
}
}
/// <summary>
/// 新增
/// </summary>
/// <param name="data"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public bool insertTimeAttendance_AttendanceInformation_machineBll(TimeAttendance_AttendanceInformation_machine data, string SQLCommand)
{
if (taid.insertTimeAttendance_AttendanceInformation_machineDal(data, SQLCommand) > 0)
{
return(true);
}
else
{
return(false);
}
}
void SetDataGridView(TimeAttendance_AttendanceInformation_machine data)
{
if (data == null)
{
return;
}
txt_MachineCoding.Text = data.MachineID;
txt_IPAddress.Text = data.IPAddress;
txt_BaudRate.Text = data.BaudRate;
com_COMmouth.Text = data.ComInterface;
com_machine.Text = data.MachinePosition;
com_MachineUse.Text = data.MachineUse;
}
TimeAttendance_AttendanceInformation_machine GetTimeAttendance_AttendanceInformation_machine()
{
TimeAttendance_AttendanceInformation_machine tai = new TimeAttendance_AttendanceInformation_machine()
{
MachineID = txt_MachineCoding.Text.Trim(),
BaudRate = txt_BaudRate.Text.Trim(),
IPAddress = txt_IPAddress.Text.Trim(),
ComInterface = com_COMmouth.Text.Trim(),
MachinePosition = com_machine.Text.Trim(),
MachineUse = com_MachineUse.Text.Trim()
};
return(tai);
}