public AttrDefine QueryOne(long tmpId, string attrId, string attrNm, string attrTp) { SqlConnection sqlConnection = DBConnection.OpenConnection(); string sql = "SELECT * FROM AttrDefine WHERE 0 = 0" + $" AND TmpId = {tmpId}" + $" AND AttrId = '{attrId}'" + $" AND AttrNm = '{attrNm}'" + $" AND AttrTp = '{attrTp}'"; AttrDefine attrDefine = null; using (SqlCommand command = new SqlCommand(sql, sqlConnection)) { SqlDataReader dataReader = command.ExecuteReader(); if (dataReader.HasRows) { dataReader.Read(); attrDefine = new AttrDefine { TmpId = (long)dataReader["TmpId"], AttrId = dataReader["AttrId"].ToString(), AttrNm = dataReader["AttrNm"].ToString(), AttrTp = dataReader["AttrTp"].ToString(), LockFlag = (int)dataReader["LockFlag"], CrtDate = dataReader["CrtDate"].ToString(), Crter = dataReader["Crter"].ToString(), LstUpdtDate = dataReader["LstUpdtDate"].ToString(), LstUpdter = dataReader["LstUpdter"].ToString(), }; dataReader.Close(); } else { dataReader.Close(); DBConnection.CloseConnection(sqlConnection); string logMessage = string.Format("未找到记录!TmpId[{0}]AttrId[{1}]AttrNm[{2}]AttrTp[{3}]", tmpId, attrId, attrNm, attrTp); log.Error(logMessage); var responseMessge = new HttpResponseMessage(HttpStatusCode.NotFound) { Content = new StringContent(logMessage), ReasonPhrase = "AttrDefine record not found" }; throw new HttpResponseException(responseMessge); } } DBConnection.CloseConnection(sqlConnection); return(attrDefine); }
public void Insert(AttrDefine attrDefine) { SqlConnection sqlConnection = DBConnection.OpenConnection(); string crtDate = DateTime.Now.ToString("yyyyMMdd HH:mm:ss"); string sql = "INSERT INTO AttrDefine " + $"(TmpId, AttrId, AttrNm, AttrTp,CrtDate, Crter) Values ({attrDefine.TmpId},'{attrDefine.AttrId}', '{attrDefine.AttrNm}', '{attrDefine.AttrTp}', '{crtDate}','{attrDefine.Crter}')"; using (SqlCommand command = new SqlCommand(sql, sqlConnection)) { try { command.ExecuteNonQuery(); } catch (Exception e) { log.Error("INSERT INTO AttrDefine ERROR!", e); DBConnection.CloseConnection(sqlConnection); throw; } } DBConnection.CloseConnection(sqlConnection); }