/// <summary>
/// 执行SQL
/// </summary>
public void Commit(Microsoft.Practices.EnterpriseLibrary.Data.Database dbinstance)
{
if (_buf.Length > 0 && dbinstance != null)
{
dbinstance.ExecuteNonQuery(System.Data.CommandType.Text, _buf.ToString());
}
}
private void GvList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewColumn column = GvList.Columns[e.ColumnIndex];
var id = GvList.Rows[e.RowIndex].Cells["id"].Value.ToString();
var ProjectNo = GvList.Rows[e.RowIndex].Cells["ProjectNo"].Value.ToString();
var PartNo = GvList.Rows[e.RowIndex].Cells["PartNo"].Value.ToString();
var PartName = GvList.Rows[e.RowIndex].Cells["PartName"].Value.ToString();
if (column is DataGridViewButtonColumn)
{
var temp = column as DataGridViewButtonColumn;
if (temp.DefaultCellStyle.NullValue.ToString() == "删除")
{
if (MessageBox.Show("确定要删除数据吗 ?删除数据将不可恢复！", "Confirm Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
SqlParameter[] p = new SqlParameter[] {
new SqlParameter("@MeasReportID", id),
};
var dbc = db.GetStoredProcCommand("DeleteMeasurementReports");
dbc.Parameters.AddRange(p);
var number = db.ExecuteNonQuery(dbc);
if (number > 0)
{
GvBind();
}
else
{
MessageBox.Show("删除失败");
}
}
}
else if (temp.DefaultCellStyle.NullValue.ToString() == "查询")
{
FrmIndex1 _FrmIndex1 = new FrmIndex1(int.Parse(id), ProjectNo, PartNo, PartName);
_FrmIndex1.Show();
}
else
{
MessageBox.Show("未知响应事件");
}
}
}
}
/// <summary>
/// 选中页码上传图片
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtYM.Text.Trim()))
{
MessageBox.Show("页码不能为空！");
return;
}
//创建一个对话框对象
OpenFileDialog ofd = new OpenFileDialog();
//为对话框设置标题
ofd.Title = "请选择上传的图片";
//设置筛选的图片格式
ofd.Filter = "图片格式|*.jpg";
//设置是否允许多选
ofd.Multiselect = false;
//如果你点了“确定”按钮
if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
//获得文件的完整路径（包括名字后后缀）
string filePath = ofd.FileName;
int position = filePath.LastIndexOf("\\");
//从完整路径中截取出来文件名“1.jpg”
string fileName = filePath.Substring(position + 1);
Byte[] bytes = GetContent(filePath);
MemoryStream ms = new MemoryStream(bytes);
//测点信息表上传图片
string strMeasPageID = GetMeasPageID(comboBox1.SelectedValue.ToString(), comboBox2.SelectedValue.ToString(), txtYM.Text.Trim());
string strSqlMeasPage = " update MeasurementPages set MeasPageImage=@Picture " + " where MeasPageID=" + strMeasPageID;
DbCommand dbc = db.GetSqlStringCommand(strSqlMeasPage);
db.AddInParameter(dbc, "@Picture", DbType.AnsiString, bytes);
int ipa = db.ExecuteNonQuery(dbc);
this.pictureBox1.Image = Image.FromStream(ms);
}
}
/// <summary>
/// Execute the non query like insert, delete and update.
/// </summary>
/// <param name="command"></param>
/// <returns>Numbers of rows affected.</returns>
public static int ExecuteNonQuery(DbCommand command)
{
int rowsAffected = 0;
try
{
Microsoft.Practices.EnterpriseLibrary.Data.Database db = DBSelector.Instance.GetDataBase;
rowsAffected = db.ExecuteNonQuery(command);
}
catch (Exception ex)
{
VaaaN.MLFF.Libraries.CommonLibrary.Logger.Log.WriteGeneralLog("Failed to execute non query." + ex.Message);
throw ex;
}
return rowsAffected;
}
private void GvList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewColumn column = GvList.Columns[e.ColumnIndex];
var id = GvList.Rows[e.RowIndex].Cells["id"].Value.ToString();
if (column is DataGridViewButtonColumn)
{
var temp = column as DataGridViewButtonColumn;
if (temp.DefaultCellStyle.NullValue.ToString() == "处理")
{
if (MessageBox.Show("你确定要设置成已经处理吗！", "Confirm Message", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
SqlParameter[] p = new SqlParameter[] {
new SqlParameter("@id", id),
};
var dbc = db.GetSqlStringCommand("UPDATE [dbo].[Warnings] SET [DoTime] = getdate(),[status] = 1 WHERE id=@id");
dbc.Parameters.AddRange(p);
var number = db.ExecuteNonQuery(dbc);
if (number > 0)
{
bind();
}
else
{
MessageBox.Show("提交数据失败");
}
}
}
else
{
MessageBox.Show("未知响应事件");
}
}
}
}
public IHttpActionResult PostMeasureData(MeasureData measureData)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var day1 = measureData.checktime.ToString("yyyy-MM-dd");
//var t1 = checktime(day1);
//var t2 = checktime(day2);
string sql = @"
delete from [TestData] where [TestData_PointSetting_ID] = {0} and TestData_User='******' and [TestData_Date] = '{1}'
";
var ttt = string.Format(sql, measureData.PointId, day1, measureData.Username);
var ds = _db.ExecuteNonQuery(CommandType.Text, ttt);
string insert = @"
INSERT INTO [dbo].[TestData]
([TestData_PointSetting_ID]
,[TestData_Value1]
,[TestData_Value2]
,[TestData_Value3]
,[TestData_Value4]
,[TestData_Value5]
,[TestData_Value6]
,[TestData_Value7]
,[TestData_Value8]
,[TestData_Value9]
,[TestData_Value10]
,[TestData_User]
,[TestData_SubmitTime]
,[TestData_Date]
,[TestData_UpperTolerance]
,[TestData_LowerTolerance]
)
VALUES
({0}
,'{1}'
,'{2}'
,'{3}'
,'{4}'
,'{5}'
,'{6}'
,'{7}'
,'{8}'
,'{9}'
,'{10}'
,'{11}'
,getdate()
,'{12}'
,{13}
,{14}
);
";
var temp = string.Format(insert, measureData.PointId,
measureData.Value1,
measureData.Value2,
measureData.Value3,
measureData.Value4,
measureData.Value5,
measureData.Value6,
measureData.Value7,
measureData.Value8,
measureData.Value9,
measureData.Value10,
measureData.Username,
measureData.checktime.ToString("yyyy-MM-dd"),
string.IsNullOrWhiteSpace(measureData.UpperTolerance) ? "null" : measureData.UpperTolerance,
string.IsNullOrWhiteSpace(measureData.LowerTolerance) ? "null" : measureData.LowerTolerance
);
_db.ExecuteNonQuery(CommandType.Text, temp);
//var model = db.MeasureDatas.Where(
// b => b.ProjectName == measureData.ProjectName
// && b.ProductName == measureData.ProductName
// && b.TargetName == measureData.TargetName
// && b.MeasurePoint == measureData.MeasurePoint
// && b.Direction == measureData.Direction
// && b.Username == measureData.Username
// && b.Timestamp > t1
// && b.Timestamp < t2
// );
//if (null != model)
//{
// db.MeasureDatas.RemoveRange(model);
//}
//db.MeasureDatas.Add(measureData);
//db.SaveChanges();
ServiceReference1.WCFServiceClient client = new ServiceReference1.WCFServiceClient();
client.StartStatic(ServiceReference1.SourceType.Standard);
return(CreatedAtRoute("DefaultApi", new { id = measureData.Id }, measureData));
}
private void dgvList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
DataGridViewColumn column = dgvList.Columns[e.ColumnIndex];
if (column is DataGridViewButtonColumn)
{
var temp = column as DataGridViewButtonColumn;
if (temp.DefaultCellStyle.NullValue.ToString() == "上传")
{
DataGridViewRow Row = dgvList.Rows[e.RowIndex];
var cel1 = Row.Cells["Value1"].Value ?? "";
var cel2 = Row.Cells["Value2"].Value ?? "";
var cel3 = Row.Cells["Value3"].Value ?? "";
var cel4 = Row.Cells["Value4"].Value ?? "";
var cel5 = Row.Cells["Value5"].Value ?? "";
var cel6 = Row.Cells["Value6"].Value ?? "";
var cel7 = Row.Cells["Value7"].Value ?? "";
var cel8 = Row.Cells["Value8"].Value ?? "";
var cel9 = Row.Cells["Value9"].Value ?? "";
var cel10 = Row.Cells["Value10"].Value ?? "";
var id = Row.Cells["ID"].Value ?? "";
SqlParameter[] p = new SqlParameter[] {
new SqlParameter("@Value1", cel1),
new SqlParameter("@Value2", cel2),
new SqlParameter("@Value3", cel3),
new SqlParameter("@Value4", cel4),
new SqlParameter("@Value5", cel5),
new SqlParameter("@Value6", cel6),
new SqlParameter("@Value7", cel7),
new SqlParameter("@Value8", cel8),
new SqlParameter("@Value9", cel9),
new SqlParameter("@Value10", cel10),
new SqlParameter("@id", id)
};
var dbc = db.GetSqlStringCommand("UPDATE [dbo].[MeasureDatas] SET [Value1] = @Value1,[Value2] = @Value2,[Value3] = @Value3,[Value4] = @Value4,[Value5] = @Value5,[Value6] = @Value6,[Value7] = @Value7,[Value8] = @Value8,[Value9] = @Value9,[Value10] = @Value10 WHERE ID=@ID");
dbc.Parameters.AddRange(p);
var number = db.ExecuteNonQuery(dbc);
if (number > 0)
{
MessageBox.Show("修改成功");
}
else
{
MessageBox.Show("删除失败");
}
}
}
}
}
/// <summary>
/// Execute an SQL command (statement) and return the number of rows affected
/// </summary>
public int ExecuteNonQuery(DbCommand com)
{
Log.Debug("\tSQL Command: " + com.CommandText);
return(Db.ExecuteNonQuery(com));
}