/// <summary>
/// hàm thực hiện việc xác nhận thông tin
/// </summary>
/// <param name="objPhieuNhap"></param>
/// <returns></returns>
public ActionResult HuyXacNhanPhieuTraLaiKho(TPhieuNhapxuatthuoc objPhieuNhap)
{
HisDuocProperties objHisDuocProperties = PropertyLib._HisDuocProperties;
string errorMessage = "";
try
{
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema)
.Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu);
TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection =
sqlQuery.ExecuteAsCollection <TPhieuNhapxuatthuocChitietCollection>();
foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection)
{
//Kiểm tra ở kho nhập xem thuốc đã sử dụng chưa
ActionResult _Kiemtrathuochuyxacnhan = Kiemtrathuochuyxacnhan(objPhieuNhap, objPhieuNhapCt);
if (_Kiemtrathuochuyxacnhan != ActionResult.Success)
{
return(_Kiemtrathuochuyxacnhan);
}
int id_thuockho = -1;
StoredProcedure sp = SPs.ThuocNhapkhoOutput(objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan,
objPhieuNhapCt.SoLuong, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat),
objPhieuNhapCt.IdThuoc, objPhieuNhap.IdKhonhap, objPhieuNhapCt.MaNhacungcap,
objPhieuNhapCt.SoLo, objPhieuNhapCt.SoDky, objPhieuNhapCt.SoQdinhthau, -1, id_thuockho,
objPhieuNhap.NgayXacnhan, objPhieuNhapCt.GiaBhyt, objPhieuNhapCt.GiaPhuthuDungtuyen, objPhieuNhapCt.GiaPhuthuTraituyen, objPhieuNhapCt.KieuThuocvattu);
sp.Execute();
sp = SPs.ThuocXuatkho(objPhieuNhap.IdKhoxuat, objPhieuNhapCt.IdThuoc,
objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan,
Utility.DecimaltoDbnull(objPhieuNhapCt.Vat),
Utility.Int32Dbnull(objPhieuNhapCt.SoLuong), objPhieuNhapCt.IdThuockho, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo, objHisDuocProperties.XoaDulieuKhiThuocDaHet ? 1 : 0, errorMessage);
sp.Execute();
errorMessage = Utility.sDbnull(sp.OutputValues[0]);
}
//Xóa toàn bộ chi tiết trong TBiendongThuoc
new Delete().From(TBiendongThuoc.Schema)
.Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu).Execute();
new Update(TPhieuNhapxuatthuoc.Schema)
.Set(TPhieuNhapxuatthuoc.Columns.IdNhanvien).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0)
.Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute();
}
Scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception exception)
{
log.Error("Loi ban ra tu sp :{0}", errorMessage);
log.Error("Loi trong qua trinh xac nhan don thuoc :{0}", exception);
return(ActionResult.Error);
}
}
public long NewAdd <T>(T item) where T : class, new()
{
if (_options.Contains(SimpleRepositoryOptions.RunMigrations))
{
Migrate <T>();
}
var tbl = _provider.FindOrCreateTable <T>();
var cmd = new StoredProcedure(tbl.Name.ToUpper() + "_PROC_INS", _provider);
var hashed = item.ToDictionary();
int pkIndex = 0;
for (int i = 0; i < tbl.Columns.Count; i++)
{
var col = tbl.Columns[i];
if (col.AutoIncrement)
{
cmd.Command.AddOutputParameter("P_" + col.Name.ToUpper(), System.Data.DbType.Int64);
pkIndex = i;
}
else
{
cmd.Command.AddParameter("P_" + col.Name.ToUpper(), hashed[col.Name], col.DataType);
}
}
cmd.Execute();
long?returnId = cmd.Command.Parameters[pkIndex].ParameterValue as long?;
return(returnId.GetValueOrDefault());
}
private List <EmailIndicator> GetEmailIndicatorList(EmailStateRequest filters)
{
var response = new List <EmailIndicator>();
var sessionId = Guid.NewGuid();
StoredProcedure storedProcedure = CreateStoredProcedure(filters, sessionId);
Select select = CreateSessionSelect(sessionId);
Delete delete = CreateSessionDelete(sessionId);
using (DBExecutor dbExecutor = UserConnectionSafe.EnsureDBConnection()) {
storedProcedure.Execute(dbExecutor);
using (var reader = select.ExecuteReader(dbExecutor)) {
while (reader.Read())
{
var emailStateItem = new EmailIndicator();
emailStateItem.Caption = reader.GetColumnValue <string>("Caption");
object benchmarkValue = reader["Benchmark"];
if (benchmarkValue != DBNull.Value)
{
emailStateItem.Benchmark = UserConnectionSafe.DBTypeConverter.DBValueToInt(benchmarkValue);
}
object actualCountValue = reader["ActualCount"];
if (actualCountValue != DBNull.Value)
{
emailStateItem.ActualValue = UserConnectionSafe.DBTypeConverter.DBValueToInt(actualCountValue);
}
emailStateItem.State = reader.GetColumnValue <string>("State");
response.Add(emailStateItem);
}
}
delete.Execute(dbExecutor);
}
return(response);
}
public void TestTransaction()
{
using (DbConnection connection = GetConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
const string newName = "changed";
StoredProcedure changeName = new StoredProcedure("ChangeName");
changeName.Command.AddParameter("@Id", 2, DbType.Int32, 4);
changeName.Command.AddParameter("@NewName", newName, DbType.String, 50);
changeName.Execute(transaction);
StoredProcedure getName = new StoredProcedure("GetName");
getName.Command.AddParameter("@Id", 2, DbType.Int32, 4);
Assert.AreEqual(newName, getName.ExecuteScalar(transaction), "The name has not been changed");
transaction.Rollback();
Assert.AreEqual("name2", getName.ExecuteScalar(), "The name has not been reverted");
connection.Close();
}
}
protected virtual void ExecuteStoreProcedureWithParameters(string procedureName, Dictionary <string, object> parameters)
{
var storedProcedure = new StoredProcedure(_userConnection, procedureName);
parameters.ForEach(p => storedProcedure.WithParameter(p.Key, p.Value));
storedProcedure.Execute();
}
protected void CTYS_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
DataObjectCommunity community = (DataObjectCommunity)e.Item.DataItem;
Literal literal = (Literal)e.Item.FindControl("CTYTITLE");
if (community.ObjectType == Helper.GetObjectTypeNumericID("ProfileCommunity"))
{
literal.Text = GuiLanguage.GetGuiLanguage("ProfileData").GetString("MyProfile");
}
else
{
literal.Text = community.Title;
}
StoredProcedure sp = SPs.HispDataObjectFindInCommunity(dataObject.ObjectID, community.ObjectID.Value, null);
sp.Execute();
bool ObjectFound = Convert.ToBoolean(sp.OutputValues[0]);
literal = (Literal)e.Item.FindControl("CTYSEL");
if (!ObjectFound)
{
literal.Text = "<input type=\"checkbox\" name=\"CTYSEL\" value=\"" + community.ObjectID.Value.ToString() + "\"/>";
}
else
{
literal.Text = "<input type=\"checkbox\" name=\"CTYSEL\" checked='true' disabled='true' value=\"\" />";
}
}
private void ClearUnusedReference()
{
var storedProcedure = new StoredProcedure(UserConnection, "tsp_RemoveUnusedReferences") as StoredProcedure;
storedProcedure.PackageName = "tspkg_Translation";
storedProcedure.Execute();
}
public List <ReportModel> Get(ReportSearchInfo param)
{
var sp = " PRC_GetReport @Report= '" + param.Report + "',@ReportType='" + param.ReportType + "',@FromDate='" + param.FromDate + "',@ToDate='" + param.ToDate + "', @UserName='******', @Type='" + param.Type + "',@AreaType='" + param.AreaType + "'";
var reportModel = StoredProcedure <ReportModel> .Execute(sp, new StoredProcedureParams()).ToList();
return(reportModel);
}
public bool ValidateLogin()
{
bool result;
StoredProcedure proc = new StoredProcedure(Constants.CONNECTION_STRING, Constants.STORED_PROC_VALIDATE_LOGIN);
proc.AddInput("@userName", UserName.Trim(), System.Data.SqlDbType.VarChar);
proc.AddInput("@password", Password.Trim(), System.Data.SqlDbType.VarChar);
System.Data.SqlClient.SqlParameter idParam = proc.AddOutput("@userId", System.Data.SqlDbType.Int);
result = proc.Execute();
if (result)
{
if (idParam.Value != DBNull.Value)
{
UserId = Convert.ToInt32(idParam.Value);
}
else
{
UserId = 0;
}
}
else
{
UserId = 0;
}
return(result);
}
private void cmdLuuLai_Click(object sender, EventArgs e)
{
foreach (Janus.Windows.GridEX.GridEXRow grdExRow in grdPresDetail.GetDataRows())
{
int IdCapPhatCt = Utility.Int32Dbnull(grdExRow.Cells[TPhieuCapphatNoitruCt.Columns.IdCapPhatCt].Value);
int presdetail_id = Utility.Int32Dbnull(grdExRow.Cells[TPhieuCapphatNoitruCt.Columns.IdDonthuocCtiet].Value);
int soluong = Utility.Int32Dbnull(grdExRow.Cells[TPhieuCapphatNoitruCt.Columns.SoLuong].Value);
int DaLinh = Utility.Int32Dbnull(grdExRow.Cells[TPhieuCapphatNoitruCt.Columns.DaLinh].Value);
// int value = Utility.Int32Dbnull(e.Value);
StoredProcedure sp = SPs.DuocUpdateLinhSoLuongThuoc(IdCapPhatCt, presdetail_id, DaLinh);
sp.Execute();
var query = from thuoc in m_dtPhieuCapPhatLichSuCT.AsEnumerable()
where
Utility.Int32Dbnull(TPhieuCapphatNoitruCt.Columns.IdCapPhatCt) ==
Utility.Int32Dbnull(grdExRow.Cells[TPhieuCapphatNoitruCt.Columns.IdCapPhatCt].Value)
select thuoc;
if (query.Any())
{
var firstrow = query.FirstOrDefault();
if (firstrow != null)
{
firstrow[TPrescriptionDetail.Columns.SluongLinh] = soluong == 1 ? soluong : 0;
firstrow.AcceptChanges();
}
}
grdPresDetail.UpdateData();
}
}
public bool UpdatePassword(string oldPassword)
{
bool result;
StoredProcedure proc = new StoredProcedure(Constants.CONNECTION_STRING, Constants.STORED_PROC_CHANGE_PASSWORD);
proc.AddInput("@userId", UserId, System.Data.SqlDbType.Int);
proc.AddInput("@oldPassword", oldPassword.Trim(), System.Data.SqlDbType.VarChar);
proc.AddInput("@newPassword", Password.Trim(), System.Data.SqlDbType.VarChar);
System.Data.SqlClient.SqlParameter resultParam = proc.AddOutput("@result", System.Data.SqlDbType.Bit);
result = proc.Execute();
if (result)
{
result = Convert.ToBoolean(resultParam.Value);
if (!result)
{
throw new Exception("Old password incorrect.");
}
}
return(result);
}
/// <summary>
/// Begin search process.
/// </summary>
public void BeginSearch()
{
Guid operationId = DeduplicationConsts.SearchOperationId;
bool isFeatureEnable = _userConnection.GetIsFeatureEnabled("FindDuplicatesOnSave");
string tspFindDuplicateName = string.Format(FindDuplicateProcedurePattern, _schemaName);
if (isFeatureEnable)
{
tspFindDuplicateName = string.Format(FindDuplicateProcedurePattern, String.Empty);
}
if (!Locker.CanExecute(operationId, _schemaName))
{
return;
}
Guid conversationId = ConversationProvider.BeginConversation(tspFindDuplicateName);
try {
Locker.SetLockState(conversationId, _schemaName, operationId, true);
var storedProcedure = new StoredProcedure(_userConnection, tspFindDuplicateName);
if (isFeatureEnable)
{
storedProcedure.WithParameter("schemaName", _schemaName);
storedProcedure.WithParameter("xmlRows", String.Empty);
storedProcedure.WithParameter("sysAdminUnit", _userConnection.CurrentUser.Id);
}
storedProcedure.Execute();
ConversationProvider.EndConversation(conversationId);
CreateSuccessReminding();
} catch (Exception e) {
ConversationProvider.EndConversationWithError(conversationId, CommonSqlExceptionCode, e.Message);
CreateReminding(_userConnection.GetLocalizableString("DeduplicationActionHelper", "FaildDuplicatesSearchMessage"));
} finally {
Locker.SetLockState(conversationId, _schemaName, operationId, false);
}
}
private void LaySokham(int status, TextBox lblQMSNumber, string MaKhoa, string madoituongkcb, int IsUuTien, ref string qmsNumber)
{
try
{
int num = 0;
int sttkham = 0;
StoredProcedure procedure = SPs.QmsTaoso(new int?(status), _QMSProperties.MaQuay, MaKhoa, id_KhoaKcb, madoituongkcb, new int?(num), sttkham, _QMSProperties.PrintStatus ? true : false, 0, new int?(IsUuTien), this.id_kieukham, this.id_phongkham, id_dichvukcb);
procedure.Execute();
int SttKham = Utility.Int32Dbnull(procedure.OutputValues[1]);
UpdateSTTKham(SttKham);
num = Utility.Int32Dbnull(procedure.OutputValues[0]);
string str = Utility.sDbnull(num);
if (Utility.Int32Dbnull(num) < 10)
{
str = Utility.FormatNumberToString(num, "00");
}
qmsNumber = str;
if (_OnCreatedQMSNumber != null)
{
_OnCreatedQMSNumber(str);
}
str = Utility.sDbnull(SttKham);
if (Utility.Int32Dbnull(SttKham) < 10)
{
str = Utility.FormatNumberToString(SttKham, "00");
}
lblQMSNumber.Text = Utility.sDbnull(str);
}
catch (Exception ex)
{
Utility.ShowMsg("Lỗi khi thực hiện lấy số thứ tự tiếp đón\n" + ex.Message);
}
}
public void ThemPhieuXuatTH(DPhieuXuatBnhan objectPhieuxuatBN)
{
try
{
DPhieuXuatBnhan _phieuxuatBN = new DPhieuXuatBnhan();
_phieuxuatBN = objectPhieuxuatBN;
_phieuxuatBN.IsNew = true;
_phieuxuatBN.Save();
StoredProcedure sp = SPs.DPhieuXuatBnhanInsert(objectPhieuxuatBN.IdPhieuXuatBn,
objectPhieuxuatBN.MaPhieuXuatBn,
objectPhieuxuatBN.NgayXuatBn, objectPhieuxuatBN.NgayKeDon,
objectPhieuxuatBN.TenBenhnhan, objectPhieuxuatBN.TenKhongDau,
objectPhieuxuatBN.Gtinh, objectPhieuxuatBN.ChanDoan,
objectPhieuxuatBN.MaBenh, objectPhieuxuatBN.DiaChi,
objectPhieuxuatBN.NamSinh, objectPhieuxuatBN.SoThe,
objectPhieuxuatBN.IdDoiTuong,
objectPhieuxuatBN.IdNhanVien,
objectPhieuxuatBN.IdDonThuoc, objectPhieuxuatBN.IdKhoaCd,
objectPhieuxuatBN.IdBacsiKedon, objectPhieuxuatBN.IdKhoXuat,
objectPhieuxuatBN.HienThi, objectPhieuxuatBN.NoiTru,
objectPhieuxuatBN.LoaiDthuoc, objectPhieuxuatBN.TrangThai,
objectPhieuxuatBN.Ngaytao, objectPhieuxuatBN.NguoiTao,
objectPhieuxuatBN.LoaiPhieu);
sp.Execute();
objectPhieuxuatBN.IdPhieuXuatBn = Utility.Int32Dbnull(sp.OutputValues[0]);
// return ActionResult.Success;
}
catch (Exception)
{
}
}
/// <summary>
/// Removes table from DB or makes it empty if is needed.
/// </summary>
/// <param name="tableName">Name of the table.</param>
/// <param name="userConnection">User connection instance.</param>
/// <param name="truncateData">Truncate table if this is needed.</param>
public static void DropTable(string tableName, UserConnection userConnection, bool truncateData)
{
var sp = new StoredProcedure(userConnection, "tsp_DropOrTruncateTable");
sp.WithParameter("tableName", tableName);
sp.WithParameter("isTruncate", truncateData ? 1 : 0);
sp.Execute();
}
/// <summary>
/// Calculate completeness for records by completeness Id.
/// </summary>
/// <param name="completenessId">Completeness Id.</param>
public virtual void RecalculateAllByCompleteness(Guid completenessId)
{
StoredProcedure recalculateAllBySchema =
new StoredProcedure(AppConnection.SystemUserConnection, "tsp_CompletenessRenew")
.WithParameter(new QueryParameter("CompletenessId", completenessId, "Guid")) as StoredProcedure;
recalculateAllBySchema.PackageName = "tspkg_Completeness";
recalculateAllBySchema.Execute();
}
/// <summary>
/// Activate bulk emails used in campaign
/// </summary>
/// <param name="campaignId">Unique identifier of campaign.</param>
/// <param name="userConnection">User connection.</param>
private void ActivateReferencedCampaignEmails(Guid campaignId, UserConnection userConnection)
{
var storedProcedure = new StoredProcedure(UserConnection, "tsp_ActivateBulkEmailByCampaign");
storedProcedure.WithParameter(campaignId);
using (DBExecutor dbExecutor = userConnection.EnsureDBConnection()) {
storedProcedure.Execute(dbExecutor);
}
}
public static bool BhytKiemtratruockhiHuyinphoiBHYT(long Id_benhnhan, string ma_luotkham)
{
int _outvalue = -1;
StoredProcedure sp = SPs.BhytKiemtratruockhiHuyinphoiBHYT(Id_benhnhan, ma_luotkham, _outvalue);
sp.Execute();
_outvalue = Utility.Int32Dbnull(sp.OutputValues[0]);
return(_outvalue == 0);
}
/// <summary>
/// Moves records group to ignore list.
/// </summary>
/// <param name="schemaName">Schema name.</param>
/// <param name="deduplicateRecordIds">Unique identifiers.</param>
public void AddToIgnoreList(string schemaName, List <string> deduplicateRecordIds)
{
string duplicateRecordIdsToString = string.Join(",", deduplicateRecordIds.ToArray());
var storedProcedure = new StoredProcedure(_userConnection, "tsp_AddDuplicatesToIgnoreList");
storedProcedure.WithParameter("SchemaName", schemaName);
storedProcedure.WithParameter("Duplicates", duplicateRecordIdsToString);
storedProcedure.Execute();
}
public void Store(TestResult testResult)
{
using (
var storedProcedure = new StoredProcedure(DataBase.Default, "sp_InsertResults",
SetUpResultParameters(testResult)))
{
storedProcedure.Execute();
}
}
/// <summary>
/// hàm thực hiện việc xác nhận thông tin
/// </summary>
/// <param name="objPhieuNhap"></param>
/// <returns></returns>
public ActionResult HuyXacNhanPhieuNhapKho(TPhieuNhapxuatthuoc objPhieuNhap, ref string errMsg)
{
try
{
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema)
.Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu);
TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection =
sqlQuery.ExecuteAsCollection <TPhieuNhapxuatthuocChitietCollection>();
foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection)
{
ActionResult kiemtrathuochuyxacnhan = Kiemtrathuochuyxacnhan(objPhieuNhap, objPhieuNhapCt);
if (kiemtrathuochuyxacnhan != ActionResult.Success)
{
return(kiemtrathuochuyxacnhan);
}
//Xóa toàn bộ chi tiết trong TBiendongThuoc
new Delete().From(TBiendongThuoc.Schema)
.Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu)
.And(TBiendongThuoc.IdPhieuChitietColumn).IsEqualTo(objPhieuNhapCt.IdPhieuchitiet)
.And(TBiendongThuoc.MaLoaiphieuColumn).IsEqualTo(objPhieuNhap.LoaiPhieu).Execute();
new Update(TPhieuNhapxuatthuocChitiet.Schema).Set(TPhieuNhapxuatthuocChitiet.Columns.IdThuockho).EqualTo(-1)
.Set(TPhieuNhapxuatthuocChitiet.Columns.NgayNhap).EqualTo(null)
.Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieuchitiet).IsEqualTo(objPhieuNhapCt.IdPhieuchitiet).Execute();
StoredProcedure sp = SPs.ThuocXuatkho(objPhieuNhap.IdKhonhap, objPhieuNhapCt.IdThuoc,
objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan,
Utility.DecimaltoDbnull(objPhieuNhap.Vat), objPhieuNhapCt.SoLuong,
objPhieuNhapCt.IdThuockho, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo,
0, errMsg);
sp.Execute();
}
new Update(TPhieuNhapxuatthuoc.Schema)
.Set(TPhieuNhapxuatthuoc.Columns.IdNhanvien).EqualTo(-1)
.Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0)
.Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu).Execute();
}
Scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception ex)
{
Utility.CatchException("Lỗi khi hủy xác nhận nhập kho", ex);
return(ActionResult.Error);
}
}
public ActionResult HuyXacNhanPhieuHuy_thanhly_Thuoc(TPhieuNhapxuatthuoc objPhieuNhap, ref string errMsg)
{
HisDuocProperties objHisDuocProperties = PropertyLib._HisDuocProperties;
string errorMessage = "";
try
{
using (var Scope = new TransactionScope())
{
using (var dbScope = new SharedDbConnectionScope())
{
SqlQuery sqlQuery = new Select().From(TPhieuNhapxuatthuocChitiet.Schema)
.Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu);
TPhieuNhapxuatthuocChitietCollection objPhieuNhapCtCollection =
sqlQuery.ExecuteAsCollection <TPhieuNhapxuatthuocChitietCollection>();
foreach (TPhieuNhapxuatthuocChitiet objPhieuNhapCt in objPhieuNhapCtCollection)
{
long idthuockho = -1;
//Nhập lại kho thanh lý
StoredProcedure sp = SPs.ThuocNhapkhoOutput(objPhieuNhapCt.NgayHethan, objPhieuNhapCt.GiaNhap, objPhieuNhapCt.GiaBan,
objPhieuNhapCt.SoLuong, Utility.DecimaltoDbnull(objPhieuNhapCt.Vat),
objPhieuNhapCt.IdThuoc, objPhieuNhap.IdKhoxuat, objPhieuNhapCt.MaNhacungcap, objPhieuNhapCt.SoLo,
objPhieuNhapCt.SoDky, objPhieuNhapCt.SoQdinhthau, idthuockho, idthuockho, objPhieuNhapCt.NgayNhap, objPhieuNhapCt.GiaBhyt, objPhieuNhapCt.GiaPhuthuDungtuyen, objPhieuNhapCt.GiaPhuthuTraituyen, objPhieuNhapCt.KieuThuocvattu);
sp.Execute();
idthuockho = Utility.Int64Dbnull(sp.OutputValues[0], -1);
if (idthuockho != objPhieuNhapCt.IdThuockho)//Nếu ai đó xóa bằng tay trong bảng thuốc kho thì cần update lại
{
new Update(TPhieuNhapxuatthuocChitiet.Schema).Set(TPhieuNhapxuatthuocChitiet.Columns.IdThuockho).EqualTo(idthuockho)
.Where(TPhieuNhapxuatthuocChitiet.Columns.IdPhieuchitiet).IsEqualTo(objPhieuNhapCt.IdPhieuchitiet).Execute();
}
}
//Xóa toàn bộ chi tiết trong TBiendongThuoc
new Delete().From(TBiendongThuoc.Schema)
.Where(TBiendongThuoc.IdPhieuColumn).IsEqualTo(objPhieuNhap.IdPhieu)
.And(TBiendongThuoc.MaLoaiphieuColumn).IsEqualTo(objPhieuNhap.LoaiPhieu).Execute();
new Update(TPhieuNhapxuatthuoc.Schema)
.Set(TPhieuNhapxuatthuoc.Columns.NguoiSua).EqualTo(globalVariables.UserName)
.Set(TPhieuNhapxuatthuoc.Columns.NgaySua).EqualTo(globalVariables.SysDate)
.Set(TPhieuNhapxuatthuoc.Columns.NguoiXacnhan).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.NgayXacnhan).EqualTo(null)
.Set(TPhieuNhapxuatthuoc.Columns.TrangThai).EqualTo(0)
.Where(TPhieuNhapxuatthuoc.Columns.IdPhieu).IsEqualTo(objPhieuNhap.IdPhieu)
.And(TPhieuNhapxuatthuoc.LoaiPhieuColumn).IsEqualTo(objPhieuNhap.LoaiPhieu).Execute();
}
Scope.Complete();
return(ActionResult.Success);
}
}
catch (Exception ex)
{
Utility.CatchException("Lỗi khi hủy xác nhận phiếu ", ex);
return(ActionResult.Error);
}
}
public string GetPatientCode()
{
string MaxPatientCode = "";
StoredProcedure sp = SPs.SpGetPatientCode(MaxPatientCode);
sp.Execute();
sp.OutputValues.ForEach(delegate(object objOutput)
{
MaxPatientCode = (String)objOutput;
});
return MaxPatientCode;
}
public string GetPatientID(string sNgayThucHien, string MaDonVi)
{
string PatientID = "";
StoredProcedure sp = SPs.SpGeneratePatientID(sNgayThucHien, MaDonVi, PatientID);
sp.Execute();
sp.OutputValues.ForEach(delegate(object objOutput)
{
PatientID = (String)objOutput;
});
return PatientID;
}
/// <summary>
/// Runs stored procedure.
/// </summary>
/// <param name="userConnection">User connection instance.</param>
/// <param name="spName">Stored procedure name.</param>
/// <param name="parameters">Execution params.</param>
/// <returns>Execution results.</returns>
public static int ExecuteStoredProcedure(UserConnection userConnection, string spName,
params KeyValuePair <string, object>[] parameters)
{
var sp = new StoredProcedure(userConnection, spName);
foreach (var parameter in parameters)
{
sp.WithParameter(parameter.Key, parameter.Value);
}
return(sp.Execute());
}
public void LaySoKhamQMS(string MaQuay, string MaKhoa, string madoituongkcb, ref int SoKham, ref int idDichvukcb, ref int idQMS, byte uutien, int loaiqms, string loaiqmsbo)
{
SoKham = 0;
idDichvukcb = 0;
StoredProcedure sp = SPs.QmsLayso(MaQuay, MaKhoa, madoituongkcb, SoKham, idDichvukcb, idQMS, uutien, loaiqms, loaiqmsbo);
sp.Execute();
SoKham = Utility.Int32Dbnull(sp.OutputValues[0]);
idDichvukcb = Utility.Int32Dbnull(sp.OutputValues[1]);
idQMS = Utility.Int32Dbnull(sp.OutputValues[2]);
}
public virtual bool SearchForDuplicatesScriptTaskExecute(ProcessExecutingContext context)
{
var accountSchemaName = "Account";
var storedProcedure = new StoredProcedure(UserConnection, "tsp_GloballySearchForDuplicates");
storedProcedure.WithParameter(Column.Const(accountSchemaName));
using (var dbExecutor = UserConnection.EnsureDBConnection()) {
storedProcedure.Execute(dbExecutor);
}
return(true);
}
public void ExecutionStpUploadBayersFromFtp(string pathToBayersFile, string pathToInActivCardsFile, string pathToOursFile, string pathToScheduleFile, string pathToProdsFile)
{
var uploadBuyersFromFtp = new StoredProcedure(userConnection, "tsp_UploadFromFtp");
uploadBuyersFromFtp.WithParameter("PathToBayersFile", pathToBayersFile);
uploadBuyersFromFtp.WithParameter("PathInActivCardsFile", pathToInActivCardsFile);
uploadBuyersFromFtp.WithParameter("PathOursFile", pathToOursFile);
uploadBuyersFromFtp.WithParameter("PathSheduleFile", pathToScheduleFile);
uploadBuyersFromFtp.WithParameter("PathProdsFile", pathToProdsFile);
uploadBuyersFromFtp.PackageName = "ITS";
uploadBuyersFromFtp.Execute();
}
/// <summary>
/// Moves contact onto required step of the campaign.
/// </summary>
/// <param name="userConnection">Instance of the <see cref="Terrasoft.Core.UserConnection"/>.</param>
/// <param name="campaignId">Unique identifier of the Campaign.</param>
/// <param name="stepId">Unique identifier of the CampaignStep.</param>
/// <param name="contactId">Unique identifier of the Contact.</param>
public static void MergeContactIntoCampaign(UserConnection userConnection, Guid campaignId, Guid stepId,
Guid contactId)
{
var sp = new StoredProcedure(userConnection, "tsp_CampaignStepHandler_MergeContactIntoCampaign");
sp.WithParameter("CampaignId", campaignId);
sp.WithParameter("StepId", stepId);
sp.WithParameter("ContactId", contactId);
using (var dbExecutor = userConnection.EnsureDBConnection()) {
sp.Execute(dbExecutor);
}
}
public virtual void SetCustomRecordPosition(string tableName, Guid primaryColumnValue, string grouppingColumnNames, int position)
{
var setRecordPositionProcedure = new StoredProcedure(_userConnection, "tsp_SetRecordPosition")
.WithParameter("TableName", tableName)
.WithParameter("PrimaryColumnName", "Id")
.WithParameter("PrimaryColumnValue", primaryColumnValue)
.WithParameter("GrouppingColumnNames", grouppingColumnNames)
.WithParameter("Position", position) as StoredProcedure;
setRecordPositionProcedure.PackageName = _userConnection.DBEngine.SystemPackageName;
setRecordPositionProcedure.Execute();
}
public void SP_Should_Execute_Without_Parameter2()
{
StoredProcedure sp = new StoredProcedure("Ten Most Expensive Products", DataService.Providers["Northwind"]);
int count = 0;
using (IDataReader rdr =sp.GetReader())
{
while (rdr.Read())
count++;
rdr.Close();
}
sp.Execute();
Assert.IsTrue(count > 0);
}
public void SP_Outputs_DefaultProvider()
{
StoredProcedure sp = new StoredProcedure("SubSonicTestNW", DataService.GetInstance("Northwind"));
sp.Command.AddOutputParameter("@param");
sp.Execute();
//make sure there's outputs
Assert.IsTrue(sp.OutputValues.Count > 0);
//this SP just returns today's date.
//make sure it's right now!
DateTime dTest = Convert.ToDateTime(sp.OutputValues[0]);
Assert.IsTrue(dTest.Date == DateTime.Now.Date);
}
public void TestTransaction()
{
using (DbConnection connection = GetConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
const string newName = "changed";
StoredProcedure changeName = new StoredProcedure("ChangeName");
changeName.Command.AddParameter("@Id", 2, DbType.Int32, 4);
changeName.Command.AddParameter("@NewName", newName, DbType.String, 50);
changeName.Execute(transaction);
StoredProcedure getName = new StoredProcedure("GetName");
getName.Command.AddParameter("@Id", 2, DbType.Int32, 4);
Assert.AreEqual(newName, getName.ExecuteScalar(transaction), "The name has not been changed");
transaction.Rollback();
Assert.AreEqual("name2", getName.ExecuteScalar(), "The name has not been reverted");
connection.Close();
}
}
public void TestOutputParameterGeneric()
{
StoredProcedure sp = new StoredProcedure("OutputParameter", "default");
sp.Command.AddParameter("@First", 2, DbType.Int32, 4);
sp.Command.AddParameter("@Second", 3, DbType.Int32, 4);
sp.Command.AddOutParameter("@Result", DbType.Int32, 4);
int result;
sp.Execute(out result);
Assert.AreEqual(5, result);
}
