/// <summary>
/// 대차 INSERT UPDTAE
/// </summary>
/// <param name="GVMaster"></param>
/// <returns></returns>
public bool InsertUpdateGV_Master(GVMasterVO GVMaster)
{
try
{
using (SqlCommand comm = new SqlCommand())
{
comm.Connection = new SqlConnection(Connstr);
comm.CommandText = @" IF NOT EXISTS(SELECT GV_Code FROM GV_Master WHERE GV_Code=@GV_Code)
BEGIN
INSERT INTO GV_Master( GV_Code,GV_Name,GV_GroupCode,GV_Group,GV_Status,Ins_Date,Ins_Emp)
VALUES(@GV_Code,@GV_Name,@GV_GroupCode,@GV_Group,@GV_Status,GETDATE(),@Ins_Emp)
END
ELSE
BEGIN
UPDATE GV_Master SET GV_Code=@GV_Code,GV_Name=@GV_Name,GV_GroupCode=@GV_GroupCode,GV_Group=@GV_Group,GV_Status=@GV_Status
,Up_Date=GETDATE(),Up_Emp=@Ins_Emp
where GV_Code=@GV_Code
END" ;
comm.CommandType = CommandType.Text;
comm.Parameters.AddWithValue("@GV_Code", GVMaster.GV_Code);
comm.Parameters.AddWithValue("@GV_Name", GVMaster.GV_Name);
comm.Parameters.AddWithValue("@GV_GroupCode", GVMaster.GV_GroupCode);
comm.Parameters.AddWithValue("@GV_Group", GVMaster.GV_Group);
comm.Parameters.AddWithValue("@GV_Status", GVMaster.GV_Status);
comm.Parameters.AddWithValue("@Ins_Emp", GVMaster.Ins_Emp);
comm.Connection.Open();
int result = Convert.ToInt32(comm.ExecuteNonQuery());
comm.Connection.Close();
if (result > 0)
{
return(true);
}
return(false);
}
}
catch (Exception)
{
throw;
}
}
public bool InsertUpdateGV_Master(GVMasterVO GVMaster)
{
GV_MasterDAC dac = new GV_MasterDAC();
return(dac.InsertUpdateGV_Master(GVMaster));
}
